Hello, everyone:
How to convert '173515' to be datetime like "5:33:00 PM". Thanks.
ZYTI can guess that 5 pm comes from 17 mod 12. But how do you get 33 minutes and 00 seconds out of your sample string?
Thursday, March 8, 2012
Datetime conversion
Labels:
conversion,
convert,
database,
datetime,
everyonehow,
microsoft,
mysql,
oracle,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment