GETDATE() format for hhmmssmm 1

[scotttom]

I'm looking for the best way to get a time to a hhmmssmm format.

I've got the following....

replace(Convert (varchar(8),GetDate(), 108),':',') + '00'

But unfortunately I need the milliseconds and not just "00" at the end.

Anybody know the best way to get there?

Thanks in advance!

Best,

Scott

 

[gmmastros]

Try using style 121 instead of 108. 108 does not include milliseconds.

Here's a version that includes 3 digits for milliseconds:

Select Replace(Replace(Right(Convert(varchar(30), GetDate(), 121), 12), ':', '), '.',')

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[scotttom]

Thanks gmastros!

LEFT(Replace(Replace(RIGHT(Convert(varchar(30), GetDate(), 121), 12), ':', '), '.','),8)

got me what I need.

Thanks for pointing me in the right direction!