Support for large dates - say 5874897-12-31
Posted: Mon Oct 29, 2007 9:26 am
Hi,
I wish to insert records with large dates as in 5874897-12-31. The field can contain smaller dates as well say 101-12-31. The function date_from_string in datastage requires exact date format %yyyy-%%mm-%dd, but my data can vary from %yyy-%mm-%dd to %yyyyyyy-%mm-%dd.
Is there any way to convert such strings to date format? and also is there any upper limit on that? My database supports dates till year 5874897.
Another question is, is there any way to load dates with BC & AD values in them like - 4713-01-01 BC. My database supports it but I could not figure out how to make DataStage understand that this is a valid date. If I map varchar to date type I have to convert it manually using some function, date_from_string also does not seems to understand dates with BC, AD.
Please suggest.
I wish to insert records with large dates as in 5874897-12-31. The field can contain smaller dates as well say 101-12-31. The function date_from_string in datastage requires exact date format %yyyy-%%mm-%dd, but my data can vary from %yyy-%mm-%dd to %yyyyyyy-%mm-%dd.
Is there any way to convert such strings to date format? and also is there any upper limit on that? My database supports dates till year 5874897.
Another question is, is there any way to load dates with BC & AD values in them like - 4713-01-01 BC. My database supports it but I could not figure out how to make DataStage understand that this is a valid date. If I map varchar to date type I have to convert it manually using some function, date_from_string also does not seems to understand dates with BC, AD.
Please suggest.