DSXchange

Posted: **Mon Jun 16, 2008 12:20 am**

hi I have value
2008-03-19
I am checking it in ISvalid function as timestamp. will this is valid will pass this value

Also I have value "2008-03-19 04:22:59" & i am checking it with DATE dataype in isvalid function. Will it will pass the value

Posted: **Mon Jun 16, 2008 12:29 am**

No & No. "2008-03-19" is not a valid timestamp, and "2008-03-19 04:22:59" is not a valid date.

Posted: **Mon Jun 16, 2008 8:48 am**

I think it is a bug. It should validate in as a DATE.

Posted: **Mon Jun 16, 2008 9:32 am**

giving the date as value and ISvalid function assing to the timestamp how can it work

it is not a timestamp

Posted: **Mon Jun 16, 2008 2:20 pm**

I misread the question. In server the oconv/iconv are smart enough to convert these. I am saying on the first one if we validate on a DATE type 2008-06-16 we are failing. The job is failing hard when it gets really bad values. The purpose of this function should be to tell us it will convert without errors.