sql server query

[kaur_gurpreet]

I Have a date Field say dt1 in table tb1

i need to write a query to retrieve date formatted in dd/mm/yyyy format

the following query

select convert(datetime,dt1,103) from tb1

returns time with date

what query to use

[Markus]

Use this:
select convert(varchar(10),dt1,103) ) from tb1

[kaur_gurpreet]

thanks it works but 103 style stands for dd/mm/yy not dd/mm/yyyy

[PinkPanther2003]

Use 203.

"Add 100 to a style value to get a four-place year that includes the century (yyyy)."

It all in Books Online.

HTH,

Peter

[kaur_gurpreet]

thanks!!! i shall try