how to apply particular FORMAT of date of birth in sql Query?

Question

suppose i want the particular format of date of birth as (mm-dd-yyyy)

Answer 1

For SQL Server

SQL Server Date Formats

Answer 2

Assuming your RDBMS is SQL Server, you can do the following:

SELECT CONVERT(VARCHAR(10), [DateOfBirth], 110) 

There's more information about date formatting here.

Answer 3

SQL Server

SELECT convert(varchar, getdate(), 110)

SELECT convert(varchar, DateOfBirth, 110) FROM YourTable

How to format datetime & date in Sql Server 2005

Answer 4

If you're using Oracle:

select to_char(your_date_column,'MM-DD-YYYY') from your_date_table;

Answer 5

Use CONVERT function if it is SQL SERVER

Select CONVERT(VARCHAR(10),Birthdate,110) from YourTable

Answer 6

Although some people have listed the proper syntax for this in multiple RDBMSs (you really need to indicate which one you're using), I'd like to point out that formatting your data is typically something that should be done by the front end of your application. That's not to say that there's never a reason to do formatting in SQL, but usually it's best to just pass it as a date/time to the front end and let the front end handle how it will represent it to the user. Hopefully, you understand the difference between a date/time and a string.