How to Get a Time in a Date [Resolved]

Posted by Levyt under Sql Server on 4/30/2010 | Views : 2371 | Status : [Member] | Replies : 3

Hello

How to get time in the following date

2010-04-30 20:06:41.890

in SQL

Thanks

Levy

[Resolved]

Reply | Reply with Attachment

Posted by: Vuyiswamb on: 4/30/2010 [Member] [MVP] [Administrator] NotApplicable

0	This will do SELECT CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSecond, Thank you for posting at Dotnetfunda Vuyiswa Maseko Thank you for posting at Dotnetfunda [Administrator] Levyt, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Levyt on: 4/30/2010 [Member] Starter

0	Thank you Sir it worked. Levyt, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Vuyiswamb on: 4/30/2010 [Member] [MVP] [Administrator] NotApplicable

0	Thank you for posting at Dotnetfunda Vuyiswa Maseko Thank you for posting at Dotnetfunda [Administrator] Levyt, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts