convert datetime field to dd/mm/yyyy 1

[mrp9090]

I have a datetime field that I want to convert to dd/mm/yyyy format in my query. I have tried to cast as varchar for dd, mm, yyyy, but I don't get the leading zeroes. Can anybody help?

 

[gmmastros]

Select Convert(VarChar(10), GetDate(), 103)

Hint: The 103 is the important part

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

select convert(varchar,getdate(),103) returns 06/06/2006


AKA 666




Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/