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
isvalid function
Moderators: chulett, rschirm, roy
No & No. "2008-03-19" is not a valid timestamp, and "2008-03-19 04:22:59" is not a valid date.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
Mamu Kim