I'm using "$(ESCAPE_NONE(DATE))$(ESCAPE_NONE(TIME))" in a job step which, according to the documentation, is supposed to be the date in YYMMDD format and the time in HHMMSS format. However, the stored procedure I'm running (which has a VARCHAR parameter) is getting:
- YYYYMMDDHHMMSS - when the hour is between 10 and 23
- YYYYMMDDHMMSS - when the hour is between 1 and 9
- YYYYMMDDHHMM - when the hour is 0
So basically it's treating the time as an integer and stripping the leading "0"s
How can I stop this happening?