convert var char field to date field

[onnonn]

Hi,

I need to convert a var char field to date field (DD/MM/YYYY)

Current convertion format:
CAST(Report_Date as DATETIME)

How can i convert to Date field with date format of DD/MM/YYYY?

Thanks.

Onn Onn

[rmiao]

Try this:

select convert(datetime, report_date, 103)

[nosepicker]

No, you have to convert to datetime first and then convert to varchar with a particular style:

select CONVERT(varchar, convert(datetime, report_date), 103)