How to Get a Time in a Date [Resolved]

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

How to get time in the following date

2010-04-30 20:06:41.890


in SQL

Thanks

Levy




Responses

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

Up
0
Down

Resolved
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

Up
0
Down
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

Up
0
Down
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

Login to post response