IN SQL Server, I can use ISDATE to make sure a data field is valid. How can I do it in iSeries?
But still, how do I make sure it's a valid date ??
Looked at the thread before mine but even in this thread , whatif the date is not valid?? How to validate a date??
Code:
select date(replace(Substr(('01 12 06'), 1, 2 ) || '/' || Substr('09 25 06',3,3) || '/' || '20' || Substr('09 25 06',6,3),' ','')) from table
Looked at the thread before mine but even in this thread , whatif the date is not valid?? How to validate a date??
Comment