isvalid function

bikan · Post by **bikan** » 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

ArndW · Post by **ArndW** » 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.

kduke · Post by **kduke** » Mon Jun 16, 2008 8:48 am

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

Tej · Post by **Tej** » 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

kduke · Post by **kduke** » 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.