Home Forums SQL Server 2005 Administering datetime RE: datetime
dgrover
SSC Rookie
Points: 44
More actions
January 4, 2005 at 4:07 pm
#535884
1) WHERE (DATEDIFF(d, datelogged, GETDATE()) = 1)
2) WHERE (despatchdate BETWEEN '" & convDate(dteFromDate) & "' AND '" & convDate(dteToDate) & "')
'Using function to massage date.
3) WHERE orderdate > Getdate() - 3