Convert datetime(6/25/2014 12:00:00 AM) format to date(yyyy-MM-dd) format in SQL server...

Question

1.00/5 (2 votes)

See more:

Convert datetime(6/25/2014 12:00:00 AM) format to date(yyyy-MM-dd) format in SQL server 2008 ....Please help me

Posted 3-Jul-14 0:36am

phmani469

Updated 3-Jul-14 0:38am

v2

Add a Solution

Comments

CHill60 3-Jul-14 6:41am

You have also tagged asp.net and c# ... dates don't have "format" in databases but you can change the way they are displayed - if you are displaying the date in asp.net do you want the formatting for that instead? Post the code you are using to display the date

3 solutions

Solution 3

Hi,

You can use below line for converting

SQL

CONVERT(varchar(10),GETDATE(),126)

Posted 3-Jul-14 0:46am

Sarvesh Kumar Gupta

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jαved · Accepted Answer · 2014-07-03T00:42:00

Solution 1

Hi,
you can try-

SQL

SELECT CONVERT(CHAR(10), convert(DATE, '6/25/2014 12:00:00 AM'), 126)

Posted 3-Jul-14 0:42am

Jαved

Updated 3-Jul-14 0:44am

v2

vangapally Naveen Kumar · Accepted Answer · 2014-07-03T00:42:00

Solution 2

SELECT CONVERT(char(10), GetDate(),126)

follow this link

http://www.sql-server-helper.com/tips/date-formats.aspx[^]

Posted 3-Jul-14 0:42am

vangapally Naveen Kumar

Updated 3-Jul-14 0:45am

v2

Convert datetime(6/25/2014 12:00:00 AM) format to date(yyyy-MM-dd) format in SQL server...

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Convert datetime(6/25/2014 12:00:00 AM) format to date(yyyy-MM-dd) format in SQL server...

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us