SQL where datetime column equals today s date

Question

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

User · Answer

There might be another way  but this should work    SELECT  Title    Firstname    Surname    Company name    Interest   FROM  dbo   EXTRANET   WHERE day Submission date  day now  and       month Submission date  month now       and year Submission date  year now

User · Answer

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

User · Answer

Easy way out is to use a condition like this   use desired date   GETDATE  -1   your sql statement  date specific    GETDATE  -1

User · Answer

Can you try this   SELECT  Title    Firstname    Surname    Company name    Interest   FROM  dbo   EXTRANET users   WHERE CAST Submission date AS DATE    CAST GETDATE   AS DATE    T-SQL doesn t really have the  implied  casting like C  does - you need to explicitly use CAST  or CONVERT    Also  use GETDATE   or CURRENT TIMESTAMP to get the  now  date and time   Update  since you re working against SQL Server 2000 - none of those approaches so far work  Try this instead   SELECT  Title    Firstname    Surname    Company name    Interest   FROM  dbo   EXTRANET users   WHERE DATEADD dd  0  DATEDIFF dd  0  submission date     DATEADD dd  0  DATEDIFF dd  0  GETDATE

User · Answer

To get all the records where record  created date is today s date Use the code after WHERE clause WHERE  CAST Submission date AS DATE    CAST  curdate   AS DATE

[datetime] SQL where datetime column equals today's date?

Examples related to datetime

Examples related to sql-server-2000