Home Forums SQL Server 2008 SQL Server 2008 - General GetDate - in where clause RE: GetDate - in where clause
Informer30
SSC-Addicted
Points: 436
More actions
May 7, 2014 at 1:38 pm
#1711685
wow thanks for the quick reply it worked, i changed the day to
+ '01' as need it to represent 01 always.
Intrigued as to why need to *1000 for year and *100 month?
Will this still if work if month = 10, 11 or 12?