Leo Torres
asked on
TSQL Date Format Query Syntax
This I am sure its easy but I can find it online
I need to return a date with time as 0000 or no time
But I dont wat to use the convert because I dont what to make it a string
I like to keep it as a date
This 2011-02-27 10:52:46.310
would return 2011-02-27 00:00:00.000
or 2011-02-27
what to keep as date not using convert
Function Date(xxxxx) ?
cast ( yourfield as date)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you that was exactly what I am looking for