Hi all,
can anyone tell me what is the date constant in sql server 7, I've used getdate and date but is not recognized by sql.
'code
if getdate > '10/05/2002'
Printable View
Hi all,
can anyone tell me what is the date constant in sql server 7, I've used getdate and date but is not recognized by sql.
'code
if getdate > '10/05/2002'
Isnt it getdate()
?
that's right.Quote:
Originally posted by Blobby
Isnt it getdate()
?
...Causes an error...Code:GetDate
...Doesn't :DCode:GetDate()
Stupid SQL Server...
Also, be careful, '10/05/2002' could be 5th Oct or 10th May, depending on what format SQL Server is set to :(
I always use dates in '10 May 2002' format...just to be sure :p
Woka