Returning formated date

[Don Grover]

Hi
I have to return dates formated in different ways in an asp page from sql
server.
What function can I use or how can I return dates formated like so

I tried DATEPART ie.. but that does not work they way I would expect

"dd/mm/yy"
"dd/mm/ccyy"
"mm/dd/ccyy"
"mm/dd/yy"
"dd mmm ccyy"
"ccyymmdd"

Regards
Nancy

 

[Roji. P. Thomas]

Look at the
convert function in Bol

 

[Dan Guzman]

To add to Roji's response, consider formatting dates in your application
code. Formatting data for presentation is usually best handled in client
code.

 

[Don Grover]

Thanks all working now, had to format in code and add correct headers , now
work well.
Thanks Guys