correct format for datetime appended to filename
Posted
by
jhayes
on Server Fault
See other posts from Server Fault
or by jhayes
Published on 2009-06-25T22:36:38Z
Indexed on
2012/10/05
21:41 UTC
Read the original article
Hit count: 135
Windows
I'm trying to setup a batch file to execute a set of stored procs and dump the output to a timestamped text file. I'm having problems finding the correct format for the timestamp.
Here is what I'm using
osql.exe -S <server> -E -Q "EXEC <stored procedure> " -o "c:\filename_%date:~-0,10%_%time:~-0,10%.txt"
The error I get is:
Cannot open output file - x:\filename_Thu 06/25/_16:26:43.1.txt No such file or directory
I can't find the documentation and I've played around with it but can't find the correct format.
© Server Fault or respective owner