Convert DateTime to Unseperated String 3

[5lights]

How do I convert a DateTime to an Unseperated string?
2006-03-30 07:00:05 to 200603300700(yyyymmddhhmm)

I got a DateTime to 20060330 by Convert(nchar(8),table.field,112)
but now I need to include the time.

 

[SQLDenis]

here is one way

select left(replace(replace(replace(convert(varchar,getdate(),120),' ',''),'-',''),':',''),12)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLBill]

Use the REPLACE command. Something like:

SELECT (Convert(NCHAR(8),table.field,112) + REPLACE((Convert(NCHAR(8),table.field,108), ':', '') AS NewDateTime

-SQLBill

Posting advice: FAQ481-4875

 

[bborissov]

On top of my head:

declare @tte datetime
SET @tte = getdate()
print replace(replace(replace(convert(varchar(20),@tte,121),'-',''),':',''),' ','')

Borislav Borissov

 

[5lights]

BINGO.
Thats pretty good, you all came up with the same(relatively) answer....and it works. I'm now getting 200603300815 for 2006-03-30 08:15:32.
Thanks