how to get time (hh:mm:ss) from sql query ?

Posted by Gold on Stack Overflow See other posts from Stack Overflow or by Gold
Published on 2010-03-15T18:38:02Z Indexed on 2010/03/15 18:39 UTC
Read the original article Hit count: 183

Filed under:
|
|

hi

i have Database with date field.

i see the time like: 1900-01-01 13:38:00.000

how i can see it like: 13:38 ?

(i work on sql server 2008)

thank's in advance

© Stack Overflow or respective owner

Related posts about sql-server-2008

Related posts about query