Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
h2sut
Starting Member
40 Posts |
 Posted - 2008-09-19 : 14:43:13
|
| I have a file that has the date as 10-Jan-2008. Is there a way to convert it to look like 01/15/2008.I did a convert(datetime,[hiredate],101 from dbo.jjresults were 2008-01-15 Do i need to substring |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-09-19 : 16:38:39
|
| Format dates at your front-end client (report, web page, application, etc); do not worry about formatting in T-SQL, databases are not meant for presentation.- Jeffhttp://weblogs.sqlteam.com/JeffS |
 |
|
|
|
|
|
Date format