Need to get date and time in format of 20120817133600

Question

question

innap9999 asked Aug 18, '12

Need to get date and time in format of 20120817133600

Hello, I need to get date and time in format of 20120817133600. Tried use Convert Replace, but without success, Please help. Thank you in advance.

datetime

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2012-08-18T18:38:52Z

SirSQL answered Aug 18, '12

Try select REPLACE(REPLACE(REPLACE(replace (convert(varchar(30), GETDATE(),121), '-', ''), ' ', ''), ':', ''), '.', '')

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2015-12-31T10:30:26Z

Gazz answered Dec 31, '15

You can get the date part easily using a convert: SELECT CONVERT(date, '20120817') but to get the date and time I would use STUFF to split it up: select convert(datetime,stuff(stuff(stuff('20120817133600', 9, 0, ' '), 12, 0, ':'), 15, 0, ':')) [ https://msdn.microsoft.com/en-GB/library/ms188043.aspx][1] [1]: https://msdn.microsoft.com/en-GB/library/ms188043.aspx

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2015-12-31T12:57:12Z

JohnM answered Dec 31, '15

If you are using SQL Server 2012 and above, you can use the FORMAT function to do this very easily. DECLARE @d DATETIME = GETDATE(); SELECT FORMAT( @d, 'yyyyddMMhhmmssms' ) AS 'DateTime Result'; For reference: https://msdn.microsoft.com/en-us/library/hh213505.aspx Hope that helps!

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM commented · Dec 31, 2015 at 01:43 PM

My fault, I just realized that this is a very old thread.

0 ·

question