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 |
|
shahab03
Starting Member
28 Posts |
 Posted - 2007-05-16 : 14:34:51
|
| how can I read and load a date column from Oracle into SQL Server where date is < jan 1 1753?Is it possible to convert it? can you share the t-sql? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-05-16 : 15:42:51
|
| I think you have to import the column as varchar.Peter LarssonHelsingborg, Sweden |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-16 : 15:43:30
|
| Then try convert function in sql. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-05-17 : 01:25:10
|
| Alternatively, add 5000 year to that and import and when querying subtract 5000 yearsMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
reading dates from oracle