I have scheduled backup script that makes the database dump. How can I add the date timestamp to the file name?
I am talking about Windows and CMD.
In the command prompt and batch files, you can use
Use something like:
This will produce a filename such as
theory » echo %date% 2009-06-01 theory » echo %time% 16:30:41,46 theory » echo %time::=% 163052,17 theory » echo %time::=,% 16,30,58,68 theory » echo backup-%date%-%time::=-%.zip backup-2009-06-01-16-31-18,82.zip
Use %DATE% variable in the filename.
There is a %TIME% variable as well, but it contains characters not allowed in a file name.
Here is an example of writing a line of text into a new file, where the file created has a date and time in its name.
Thank you for your interest in this question.
Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.
Would you like to answer one of these unanswered questions instead?