Search found 1 match
- Thu Oct 01, 2009 12:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to change Date datatype so it is NOT "smalldatetime
- Replies: 0
- Views: 584
How to change Date datatype so it is NOT "smalldatetime
I am trying to insert records in a SQL Server table with date fields that are datatype "date". Somehow the date fields seem to default to "smalldatetime", which prevents me from inserting dates outside of the range between 01/01/1900 through 06/06/2079. I need to insert records w...