Shulou(Shulou.com)06/01 Report--

CMD how to create date file names, I believe that many inexperienced people do not know what to do, so this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Cause:

Add logs when you execute a SQL batch (initially there is only one log file, and you can only save logs for one day).

Now the daily log has to be recorded, and the daily log is a separate file.

Action:

At first I thought it was like this.

Osql-U sa-P cybermartmis-I E:\ SqlScript\ H3exScript\ CyberKQ.sql-o E:\ SqlScript\ H3exScript\ log\% date%_CYberKQ_log.txt

Just OK, the result is NG. The reason is that the date format of the server cannot be used as the file name (including "/")

C:\ Users\ H3Admin > echo% date% three

So the result is as follows:

Osql-U sa-P cybermartmis-I E:\ SqlScript\ H3exScript\ CyberKQ.sql-o E:\ SqlScript\ H3exScript\ log\% date:~0,4%%date:~5,2%%date:~8,2%_CYberKQ_log.txt

C:\ Users\ H3Admin > echo% date:~0,4%%date:~5,2%%date:~8,2%

After reading the above, have you mastered how CMD creates date file names? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.