MSSQL - select date field in table

Posted by thegunner on Stack Overflow See other posts from Stack Overflow or by thegunner
Published on 2010-04-13T12:39:14Z Indexed on 2010/04/13 12:42 UTC
Read the original article Hit count: 255

Filed under:

Hi,

In my table I have a date column which the date is displayed in the format "2009-11-18 10:55:28.370"

How can just get the date value of this field in a select statement. e.g.

select id from risks, where creation_date = getdate()

© Stack Overflow or respective owner

Related posts about tsql