SQL where datetime column equals today's date?
datetime, sql-server-2000
Solution
Looks like you're using SQL Server, in which case `GETDATE()` or `current_timestamp` may help you. But you will have to ensure that the format of the date with which you are comparing the system dates matches (timezone, granularity etc.)
e.g.
where convert(varchar(10), submission_date, 102)
= convert(varchar(10), getdate(), 102)
Problem
How can I get the records from a db where created date is today's date? ``` SELECT [Title], [Firstname], [Surname], [Company_name], [Interest] FROM [dbo].[EXTRANET_users] WHERE DATE(Submission_date) = DATE(NOW()) ``` This doesn't work im using sql server 2000 and submission date is a date time field