Hi

If you field is a datetime, you can use the CONVERT function to convert it
to a formatted string. See books online for more information.

John

"Leader" <sohelcsc@yahoo.com> wrote in message
news:b1a93c73.0307220003.7f068543@posting.google.c om...
> Hi All,
> I am facing a problem with a sql what i used in MS Access but its not
> returning the same result in MS Sql Server 2000. Here i am giving the
> sql:
>
> SELECT TOP 3 format( MY_DATE, "dddd mm, yyyy" ) FROM MY_TAB WHERE
> MY_ID=1
>
> The above sql in ACCESS return me the date in below format in one
> column:
>
> Friday 09, 2003
>
> But in Sql server 2000 i am not getting the same format eventhough i
> am using convert function, date part function etc.
>
> Please if you find the solution would be helpful for me..
>
> Thanks
> Hoque