How to get date format

[sooreeagt]

Hi all, How do I make the date format to DD-MMM-YYY, ie. 01-APR-1998. I have try to set 'DateStyle' to all options but none of them can show this format. Could someone help me please?

Suresh.R

[Colin Angus Mackay]

What technology are you using? (That would be a help to finding your answer)

---

Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website

[sooreeagt]

Hi i want it in SQL... my INPUT is GetDate() and OUTPUT is 9-Apr-2007...ok..

Suresh.R

[Colin Angus Mackay]

sooreeagt wrote:

i want it in SQL...

All RDBMS support SQL. Did you mean Microsoft SQL Server? If you meant SQL Server then there is no exact conversion to the format you want. Be aware that it is the responsibility of the Presentation layer to format data, not the database.

---

Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website