sql - Converting batch output into String -



sql - Converting batch output into String -

i have written simple script converts computer's date (format: mm/dd/yyyy) sql periodid (yyyymmdd).

@echo off set %mydate%=%date:~10,4%%date:~4,2%%date:~7,2%

however, output of %mydate% numeric (int). how can create %mydate%'s output becomes string?

thanks in advance!

sql batch-file scripting

Comments

Post a Comment

Popular posts from this blog

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

php - Working with pretty urls on apache and fastcgi after hhvm installation -

php - Working with pretty urls on apache and fastcgi after hhvm installation - i needed slim php work pretty urls using .htaccess , no problem. rewriteengine on rewritecond %{request_filename} !-f rewriterule ^ index.php [qsa,l] now ran using hhvm, fastcgi using virtual host config. <virtualhost *:80> servername project.dev serveralias www.project.dev documentroot /var/www/project proxypassmatch ^/(.*\.php(/.*)?)$ fcgi://127.0.0.1:9000/var/www/project/$1 <directory "/var/www/project"> allowoverride order allow,deny allow </directory> </virtualhost> of course, won't read .htaccess file, thought of adding .htaccess config in virtual host config, no, won't work. like so: <virtualhost *:80> servername project.dev serveralias www.project.dev documentroot /var/www/project proxypassmatch ^/(.*\.php(/.*)?)$ fcgi://127.0.0.1:9000/var/www/project/$1 <directory "/var/www/project"...
Read more