Hi!
Date values on the SQL Serevr are stored in the internal binary format. No matter which way you specify it, it is stored the same way after converting of the character string with date to the date field value. You need to solve this another way - convert date to 'dd/mm/yy' string after you query the data:
SELECT formatdatetime(mydate,2) as MyDate, ...
HTH.
>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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.