How do I get Date From DateTime?

[laurin1]

Unable to figure this out. I've tried using the SQL Server Compact documentation, but I can't figure out which one to use and functions like CONVERT(date, <datecolumn) through date = unknown data type.

[Tom_P · Accepted solution]

Hi,

To retrieve the date from a datetime field, you can use the cast function:

select cast(TimeGenerated as date), TimeGenerated from tblNtlog

[laurin1]

Answered my own question:

Convert(nvarchar(10),tblNtlog.TimeGenerated,120)