General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL server datetime field
On a datetime field I need to get only the date, not the time.
I've tried LEFT(CAST(datetimefld AS CHAR),11) but it gives me, of course, a char field that I cannot sort by correctly.
How can I get this as a DATE ?
Jan 11 2003 looks nice for what I want, but again, I cannot order it in this way
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only