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.

asked Aug 18 '12 at 05:42 PM in Default

(comments are locked)

1 answer:

Try

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

answered Aug 18 '12 at 06:38 PM

SirSQL
4.8k ● 1 ● 3

(comments are locked)

Your answer

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Topics:

asked: Aug 18 '12 at 05:42 PM

Seen: 221 times

Last Updated: Aug 18 '12 at 06:39 PM