charles jawahar
Newbie
Points: 1
More actions
July 8, 2004 at 9:02 pm
#108493
Hi!
Pl. help me to compare the datetime column with today's date (using getdate() function) in the where clause.
Suppose if I compare using = , since the time is not matching, i am not able to fetch the records.
Regards
Charles.
rdg
Mr or Mrs. 500
Points: 536
July 9, 2004 at 1:49 am
#513995
Charles
I think we need some more information before we can help!
Are you trying to match a record in your table with the exact date and time as the date and time found using getdate(), or is it simply records with the same date?
Frank Kalis
SSC Guru
Points: 111183
July 9, 2004 at 4:56 am
#514033
Search the forum. There are plenty of threads on how to strip the time off a datetime or how to do search an compare on datetimes.
--Frank KalisMicrosoft SQL Server MVPWebmaster: http://www.insidesql.org/blogsMy blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply