brain dump
The private thoughts and muses of a web application and software developer.
Search...
22 January 2009
SQL - Get Time From datetime Without Seconds.
LEFT(Convert(varchar, fldDate, 8), 5)
The above seems to be about the best way to return the time portion from a datetime field if you need to remove the seconds.
There has to be a neater way of doing it....anyone?
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment