How to get time in hh:mi:ss.mmm format

Question

Hi I want to get time in hh:mi:ss.mmm format in SQL Server.... Please help. Thank You...

Pravin More · Answer

Hi Kamal You can get it by thuis way.............. select convert ( varchar  getdate () 114 ) Output is like : 10:30:00:780 i hope it will work for you. Thanx Pravin.

Jaganathan Bantheswaran · Answer

Hi Try like this SELECT LTRIM(RIGHT(CONVERT(VARCHAR(24) GETDATE() 113) 12)) AS HourMinuteSecond GO