Convert from mm/dd/yyyy to yyyymmdd

Hi friends,
I have a Date column as MM/DD/YYYY(datetime) i need to convert this to YYYYMMDD(int). Can anyone help me in converting this....
i tried this, but am getting an error
SELECT
distinct convert(datetime,Date)as [YYYYMMDD]error:Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.
Thanks,
baru.

Please look into BOL for "CONVERT" function and valid parameters you can specify.SELECT
CONVERT(VARCHAR,GETDATE(),112)

I have two tables oldtbl and newtbl.I am trying to populate the newtbl from oldtbl , In Oldtbl i have a column by name Date of type (datetime).... in newtbl i have a column YYYYMMDD of type (int). To populate the newtbl column i need to convert the date.

SELECT CONVERT(VARCHAR(8),GETDATE(),112)
If i use this the output format will be yymmdd ....

actually Frank i need to convert the datatype from datetime to int... so if i use that i'll get the output in yymmdd format...but i need it in yyyymmdd format...

If you are doing this just for display purpose, you should do it at the front end.

its not just for display purpose...

Hi Guys,
I could convert datetime to int ...
i used this : convert
(char(10),Date,112)
O/P: 20030306

If you choose INT for storing dates, then you're out of luck if you ever need to use functions like DATEPART, DATEADD, DATEDIFF inside SQL Server.
In case the INT dates are a requirement for some external software, then consider creating a view that casts/converts the datetime column as an INT.

I have used your reply Madhivanan....

Thanks for your reply...