Formatting Timestamp in Batch File

To use WinSCP to save formatted timestamp to an environment variable, use:

set TIMESTAMP_FORMAT=yyyy-mm-dd
for /F "tokens=* USEBACKQ" %%F in (`winscp.com /command "echo %%TIMESTAMP#%TIMESTAMP_FORMAT%%%" "exit"`) do set TIMESTAMP=%%F
echo %TIMESTAMP%

It outputs a current date in format 2016-09-29 on any locale.

Of course, if you actually just need to print the timestamp (or output it a file), you do not need to do it indirectly via the environment variable, just use a simple:

set TIMESTAMP_FORMAT=yyyy-mm-dd
winscp.com /command "echo %%TIMESTAMP#%TIMESTAMP_FORMAT%%%" "exit"

To calculate relative times, you can extend the batch file like below. The script will print the yesterday date.

set TIMESTAMP_FORMAT=yyyy-mm-dd
set TIMESTAMP_RELATIVE=-1D
for /F "tokens=* USEBACKQ" %%F in (`winscp.com /command "echo %%TIMESTAMP%TIMESTAMP_RELATIVE%#%TIMESTAMP_FORMAT%%%" "exit"`) do set TIMESTAMP=%%F
echo %TIMESTAMP%

Change the value of the TIMESTAMP_RELATIVE variable to +1D to calculate tomorrow date.

To calculate a time one hour ago, set the TIMESTAMP_RELATIVE to -1H and change the TIMESTAMP_FORMAT to include also a time a time, e.g. yyyy-mm-dd_hh:nn:ss.

For all options of the timestamp format and the relative date/time calculation, see the %TIMESTAMP% syntax documentation.