Extract date using dos batch script in specific format

Asked Sep 05 '11 at 17:01

Active Sep 06 '11 at 13:55

Viewed 3,150 times

I need to extract the current date and time from the system and create SQL queries using a range of dates. As i am running this on Windows, it will have to be a dos batch script. Is there a way a can get the date and time in the DDMONYY,HH:MI:SS format? (e.g. 14MAR11,14:25:26)

I would like to generate ten dates in that format with each being 1 minute later than the previous date and time.

I am not an expert in dos scripting but i have found out how to write a loop in dos but not quite sure how to generate the date in the format i want it to be:

for /L %%i in (1,1,10) do (

    currentDate = currentDate + one minute
    echo "Insert into dateValue(ArrivalDates) values(%currentDate%)" > insert%i%.sql

)

Thanks in advance

edited Sep 05 '11 at 18:24

asked Sep 05 '11 at 17:01

ziggy

15,319
64
187
280

So why did you tag this powershell? – manojlds Sep 05 '11 at 18:10
is that not the same as dos batch scripting? – ziggy Sep 05 '11 at 18:24
1

No. And I advise you to learn. What you want be done much simpler with it - http://technet.microsoft.com/en-us/scriptcenter/dd742419 – manojlds Sep 05 '11 at 18:34
Try using vbscript or powershell. It will make things a hell lot easier – ghostdog74 Sep 06 '11 at 14:42

Extract date using dos batch script in specific format

0 Answers0