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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-30 : 13:59:08
|
| Anjel writes "Hi, thank you for this opportunity...I have a text file imported with the date formatted into a year column and dayofyear column. I need the dayofyear converted to a regular dd/mm format.I know about the Date conversion options such as DATEDIFF and DATEPART, but I can not seem to find a way to use them to convert Back to the regular format.Please Help!This had been done previously in Access with the following code:select Format(DateAdd("d";1;Day([DIA]) & "/" & Month([DIA]));"dd/mm/yy") as MDATEplease and Thank you oh Thank you!" |
|
|
|
|
|
DateofYear conversion