Hi,

Anyone know how to save datetime in MSSQL 7.0 in dd/mm/yy format ? I tried to use formatdatetime(mydate,2) and change my regional setting date to dd/mm/yy, but the date is still saved in mm/dd/yy.

Is there anyway to save the datetime in dd/mm/yy format ?

Regards,
Barata