Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Convert getdate()

3 Posts 3 Posters 0 Views 1 Watching

J Offline
J Offline
javierarka

wrote on last edited by

#1

How can i convert a getdate() result to a style of yyyymmddhhmmss Thanks Javierarka
A S 2 Replies Last reply

0
J javierarka

How can i convert a getdate() result to a style of yyyymmddhhmmss Thanks Javierarka
A Offline
A Offline
andyharman

wrote on last edited by

#2

select replace(convert(varchar(10), GetDate(), 112) + convert(varchar(8), GetDate(), 114), ':', '') Regards Andy
1 Reply Last reply

0
J javierarka

How can i convert a getdate() result to a style of yyyymmddhhmmss Thanks Javierarka
S Offline
S Offline
Szemi90

wrote on last edited by

#3

select replace(replace(replace(convert(varchar(19),getdate(),120),'-',''),':',''),' ','')
1 Reply Last reply

0

Log in to reply