Date Formats in SQL Server 2008

Question

1.00/5 (1 vote)

See more:

How to convert this value

SQL

08/01/2014

into this

SQL

8/1/2014

in SQL Server 2008.
any idea how to achieve this approach?

Thanks in advance!

Posted 5-Sep-14 9:13am

1 solution

Add a Solution

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

CPallini · Answer 1 · 2014-09-05T10:28:00

It is worth noting those are just two different representations of the same Date value. You haven't to convert one into the other (and viceversa). This Code Project article could help: SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.[^].