Date Conversion 2

[Rob7]

I have a date in the form of a datetime data type in a filed in sql (MM/DD/YYYY) and I want to put it in the form of yyyymmdd as an integer. Is there an easy way to do this with a sql statement in query analyzer?

Cytec Corporation
rbrown@cyteccorp.com

 

[mkrausnick]

select 10000*datepart(year,getdate())+100*datepart(month,getdate())+datepart(day,getdate())

Mike Krausnick
Dublin, California

 

[Kris11]

This might also work..

SELECT CONVERT(INTEGER,CONVERT(VARCHAR, getDate(),112))

-Kris

 

[Rob7]

Well, the only problem is that the dates are already in the fields. Won't the getdate pull the system date? I want to convert existing data.

Cytec Corporation
rbrown@cyteccorp.com

 

[MDXer]

Modify Kris11 and replace getdate() with your dat column

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[Rob7]

That worked MDXer. I had to update to a new column but I can fix that part. Thanks everybody.

Cytec Corporation
rbrown@cyteccorp.com

 

[MDXer]

The thanks should primarily go to Kris11

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck