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 - 2004-06-23 : 10:37:09
|
| syed writes "i am trying to insert date in table in the format "MAY-04" i hve tried several thing but it doesnot work nay suggestions" |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-06-23 : 10:40:36
|
| "MAY-04" would not be insertable into a Date\time Field.You would Have to use A Varchar field.JimUsers <> Logic |
 |
|
|
gpl
Posting Yak Master
195 Posts |
Posted - 2004-06-23 : 11:48:35
|
| In the past, where I have had to store a month and year, I have stored it as a date, 01/month/year, so it can be sorted correctly and then drop the day part for display purposesGraham |
|
|
|
|
|
|
Date Formatting