Home Forums SQL Server 7,2000 T-SQL Select date/time field on a daily basis RE: Select date/time field on a daily basis
john-132685
SSCertifiable
Points: 6084
More actions
December 10, 2004 at 3:24 pm
#533404
getdate() gives you current date time... converting (convert) it to string and trimming off (substring) the time portion will give you todays calendar date which you can look for all >=... or you cand use dateadd to get yesterday's...