date format in ms sql server 2000

[popskie]

hi,
How to format a date? when I query the table using query analyser the date it look this even i change the setting in the contrik panel

1948-12-08 00:00:00.000
1952-02-19 00:00:00.000
1963-08-30 00:00:00.000

I want this format guys how would i do that?
12/08/1948
02/19/1952
08/30/1693

Popskie

[pranoy]

use convert() function.

convert(varchar,getdate(),101) -> formats as mm/dd/yyyy
convert(varchar,getdate(),103) -> formats as dd/mm/yyyy
convert(varchar,getdate(),112) -> formats as yyyymmdd

[popskie]

Thank u Pranoy you've got it.