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: 253
tsql
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