How can I convert GETDATE() to this format?
-
Hi, all
Here is a q for U.
I want to convert GETDATE() to this format,YYYYMMDDHHMMSS
I tried this way but did not work..
Convert(char(14),GETDATE(),120)
Any Idea???
Thx in advance..
Jay
-
check out this evolution
select
Convert( char( 20),GETDATE(),120)
, replace( Convert( char( 20),GETDATE(),120), '-', '')
, replace( replace( Convert( char( 20),GETDATE(),120), '-', ''), ' ', '')
, replace( replace( replace( Convert( char( 20),GETDATE(),120), '-', ''), ' ', ''), ':', '')
Steve Jones
-
awesome...
Thx
Jay
quote:
check out this evolutionselect
Convert( char( 20),GETDATE(),120)
, replace( Convert( char( 20),GETDATE(),120), '-', '')
, replace( replace( Convert( char( 20),GETDATE(),120), '-', ''), ' ', '')
, replace( replace( replace( Convert( char( 20),GETDATE(),120), '-', ''), ' ', ''), ':', '')
Steve Jones
-
I added some user defined functions for working with dates.
Check out:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=175
and
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=174
-
This will do it a hair faster and with less conversions and function calls which saves on CPU cycles.
CONVERT(VARCHAR,GETDATE(),112) + REPLACE(CONVERT(VARCHAR,GETDATE(),108),':','')
-
Thx..
This works great as well...
Jay
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply