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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-11-30 : 07:34:10
|
| Hi i would like to create a date_time table with all the different date formats for 2006 in it, is there any quick way of doing this ?my table would need to have columns date ,day, month, year, quater week. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-30 : 07:37:02
|
| SELECT * INTO YourDateTable FROM F_TABLE_DATE('19000101', '20781231')Peter LarssonHelsingborg, Sweden |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Populate date_Time table