February 23, 2005 at 4:07 am
Can anyone tell me why SQL Server Agent, when executing "SELECT [DATE], [TIME]", gives me as output one record, two INT columns containing the current date and the current time?
I.e executed today gives:
----------- -----------
20050223 115419
But "SELECT [Date], [Time]" fails with: Invalid column name 'Date'. [SQLSTATE 42S22] (Error 207) Invalid column name 'Time'.
also "SELECT Date, Time" and "SELECT DATE, TIME" fails.
Any ideas?
February 23, 2005 at 12:44 pm
The SQL Server Agent has available certain case-sensitive tokens which are replaced at run time with the actual values. These are primary used for Alert Response job steps. There are 15 tokens that include [DATE] and [TIME].
See sp_add_jobstep in Book OnLine for all of the tokens.
SQL = Scarcely Qualifies as a Language
February 25, 2005 at 6:48 am
Oh, I didn't know this feature!
Thanx,
Hanslindgren
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy