I need to extract the time portion of a datetime2(7) column in hhmmssfff format and I am doing it like this:
DECLARE @mdate AS DATETIME2(7) SET @mdate = '2012-03-15 10:13:27.5437431' SELECT LEFT(REPLACE(REPLACE(CONVERT(VARCHAR ,@mdate ,114),':',''),'.',''),9)
Is there a better approach than doing this ugly replaces/convert/left?
I need this to join to a DimTime dimension whose key is in hhmmssfff format.