How to get current Time in HHmmssSSS format

Question

User-1061665085 posted

Hi,

I tried using

SELECT replace(Convert (varchar(8),GetDate(), 108),':','') + SELECT DATEPART(ms,SYSDATETIME());

but it gives only HHmmss part not milli second.

Please help!

Thanks

Aiden

Answer 1

User2103319870 posted

mr.ab18

but it gives only HHmmss part not milli second.

You just need to use DateFormat 114 instead of 108

SELECT replace(Convert (varchar(15),GetDate(), 114),':','')

Note that I have increased the size of Varchar to 15 so that it will include the microseconds also

Answer 2

User-1061665085 posted

mr.ab18

but it gives only HHmmss part not milli second.

You just need to use DateFormat 114 instead of 108

SELECT replace(Convert (varchar(15),GetDate(), 114),':','')

Thanks mate! 

Also this working after lot of try

SELECT convert(varchar,replace(Convert (varchar(8),GetDate(), 108),':','')) +  convert(varchar,DATEPART(ms,SYSDATETIME())) 

:)

Answer 3

User354416029 posted

you can do it using following query

 SELECT CAST(GetDate() AS time(7)) AS 'time'

for more reference refer msdn link .

hope this will be useful.

Thanks,

Chintan

Answer 4

User77042963 posted

select format(getdate(),'HHmmssfff')

Answer 5

User-1061665085 posted

select format(getdate(),'HHmmssfff')

 Stroke of a genius :) and thanks all other people who helped!