Date Format

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 1

Try something like:

select replace(convert(char(10),getdate(),120),'-','')

Gregory A. Larsen, DBA

Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http://www.sqlservercentral.com/bestof/

Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

dzwahlen Valued Member Points: 66 More actions · Answer 2

select Replace(Substring('2003-08-30 00:00:00',1,10),'-','')

ThomasH SSCertifiable Points: 7437 More actions · Answer 3

Here's a shameless plug for a script I submitted...

Once you understand the BITs, all the pieces come together

Jonathan SSC-Insane Points: 20427 More actions · Answer 4

Why not just use CONVERT with Type 112 (ISO)?

SELECT CONVERT(char(8),GETDATE(),112)

--Jonathan