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 |
|
ggaume
Starting Member
1 Post |
 Posted - 2007-10-25 : 11:17:44
|
| I am trying to extract the month from a date field, and I am able to get the integer for the month, however, when I try to convert the integer to the literal, e.g. 3 to March, I am having issues.I have a field called PROCES, which represents a date processed, which is numeric(8).... i.e. 20061231.I am using:SELECT datepart(mm,cast(convert(char(8),PROCES)as datetime))which gives me the correct integer.When I try:SELECT datename(mm,datepart(mm,cast(convert(char(8),PROCES)as datetime)))I get January for all records...?Does anyone know why, and how to fix. Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-10-25 : 11:23:37
|
| SELECT datename(mm,cast(convert(char(8),PROCES)as datetime))You were getting the name of the month for th month number which would be the number of days from 1 jan 1900 - always jan.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
|
|
Get Literal Month from date