Lệnh in ra ngày giờ CMD

Tạo file .cmd hoặc .bat

@echo off
for /f "tokens=1-3 delims=/ " %%a in ('date /t') do (set mydate=%%b_%%a_%%c)
For /f "tokens=1-2 delims=/:" %%a in ("%TIME%") do (set mytime=%%a_%%b)
echo Current time is %mydate%_%mytime%
set myall=%mydate%_%mytime%
echo %myall%

Ở đây token=1-3 hoặc 1-2 nghĩa là lấy biến ở vị trí 1 tới n. Ví dụ 26/02/2018 thì 26 là vị trí 1 còn 2018 là vị trí 3

Code ví dụ:

@echo off
for /f "tokens=1-3 delims=/ " %%a in ('date /t') do (set mydate=%%b_%%a_%%c)
For /f "tokens=1-2 delims=/:" %%a in ("%TIME%") do (set mytime=%%a_%%b)
echo Current time is %mydate%_%mytime%
set myall=%mydate%_%mytime%
SQLCMD -E -S TLINKVN-25208\SQLEXPRESS -Q "BACKUP DATABASE bbg_HKBV_v18 TO DISK='c:\backup\bbg_HKBV_v18-%myall%.bak'"
SQLCMD -E -S TLINKVN-25208\SQLEXPRESS -Q "BACKUP DATABASE rxjhaccount_HKBV TO DISK='c:\backup\rxjhaccount_HKBV-%myall%.bak'"
SQLCMD -E -S TLINKVN-25208\SQLEXPRESS -Q "BACKUP DATABASE PublicDB_HKBV_V18 TO DISK='c:\backup\PublicDB_HKBV_V18-%myall%.bak'"
SQLCMD -E -S TLINKVN-25208\SQLEXPRESS -Q "BACKUP DATABASE rxjhgame_HKBV TO DISK='c:\backup\rxjhgame_HKBV-%myall%.bak'"
SQLCMD -E -S TLINKVN-25208\SQLEXPRESS -Q "BACKUP DATABASE rxjhgame_HKBV_V18_1 TO DISK='c:\backup\rxjhgame_HKBV_V18_1-%myall%.bak'"