General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Chris,
107 still I cannot Sort, and 112 will be hard to read for the user.
any other ideas?
>I think this will give you the order you want:
>
>CONVERT(varchar, datetimefld, 112)
>
>While this gives the formatting:
>
>CONVERT(varchar, datetimefld, 107)
>
>
>>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
Previous
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