InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 12:51:54 GMT20http://www.sqlservercentral.com/Forums/Topic452328-338-1.aspxI believe 14 is what your looking for - [code]select replace(convert(varchar, getdate(),112),'/','') + replace(convert(varchar, getdate(),14),':','') [/code]Wed, 06 Feb 2008 10:26:52 GMTTommy Bollhoferhttp://www.sqlservercentral.com/Forums/Topic452328-338-1.aspxD'oh!:blush:Wed, 06 Feb 2008 10:22:44 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic452328-338-1.aspxHere's a couple of ideas.[code]DECLARE @Now DATETIMESET @Now = GETDATE()SELECT @NowSELECT CAST(datepart(yy, @Now) AS CHAR(4)) + RIGHT('0'+LTRIM(cast(datepart(mm, @Now) as VARCHAR(2))), 2) + RIGHT('0'+LTRIM(cast(datepart(dd, @Now) as VARCHAR(2))), 2) + RIGHT('0'+LTRIM(cast(datepart(hh, @Now) as VARCHAR(2))), 2) + RIGHT('0'+LTRIM(cast(datepart(mm, @Now) as VARCHAR(2))), 2) + RIGHT('0'+LTRIM(cast(datepart(ss, @Now) as VARCHAR(2))), 2) + RIGHT('00'+LTRIM(cast(datepart(ms, @Now) as VARCHAR(3))), 3)SELECT REPLACE(REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(28), @Now, 121), '-', ''), ' ', ''), ':', ''), '.', '')[/code]Wed, 06 Feb 2008 10:21:25 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic452328-338-1.aspxI REALLY appreciate the quick response, exactly what I needed. Wish I had asked earlier. :DWed, 06 Feb 2008 10:11:04 GMTRockStarhttp://www.sqlservercentral.com/Forums/Topic452328-338-1.aspxSELECT LEFT(REPLACE(REPLACE(REPLACE(REPLACE(CONVERT(varchar,GETDATE(), 121),'-',''),':',''),'.',''),' ',''),16)Wed, 06 Feb 2008 10:09:22 GMTJohn Rowanhttp://www.sqlservercentral.com/Forums/Topic452328-338-1.aspxTry this:select replace(replace(replace(replace(convert(varchar(30), getdate(), 121),'-',''),' ',''),':',''),'.',''):cool:Wed, 06 Feb 2008 10:03:59 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic452328-338-1.aspxyou can just convert the whole thing and strip out the characters. milliseconds is 3 digits so you'll have to truncate the result from 17 to 16 digits.select substring( replace(replace( replace(replace( convert(varchar,getdate(),121),' ',''),'-',''),':',''),'.',''), 1, 16 )Wed, 06 Feb 2008 10:03:50 GMTantonio.collinshttp://www.sqlservercentral.com/Forums/Topic452328-338-1.aspxTrying to update a timestamp field with getdate(). Field is Varchar (16) and the time needs to be in the following format : YYYYMMDDhhmmssmsExample: 2008020609435709Using the code below to get the second, but in desperate need of how to include the milliseconds in this format. Select convert(varchar(8),getdate(),112) -- YYYYMMDD +substring(convert(varchar(8),getdate(),108),1,2) --HH +substring(convert(varchar(8),getdate(),108),4,2) -- mm +substring(convert(varchar(8),getdate(),108),7,2) --ssThanks in Advance for your advice!Wed, 06 Feb 2008 09:52:54 GMTRockStar