Click here to Skip to main content
15,068,879 members
Please Sign up or sign in to vote.
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

1 solution

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.[^].
   

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




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900