validate date and populatate

[ravindrag]

i have a column xxxx it is of format yyyy/mm/dd DATE datatype(8) i have to see whether it is a valid format or not and if it is valid i have to load to target TIMESTAMP(30)? how can i see if it is valid or not

[mcolen]

You could always do an Iconv and the Status() to check if it was a valid date to convert conversly if it is valid you could use an Oconv and concatenate a dummy timestamp to the end of it.

[avi21st]

i have a column xxxx it is of format yyyy/mm/dd DATE datatype(8) i have to see whether it is a valid format or not and if it is valid i have to load to target TIMESTAMP(30)? how can i see if it is valid or not

Search the forum...there are a lot of post on this subject.

[meena]

Hi,
Check this function IsValid(date "%yyyy-%mm-%dd", SourceDate).

[ray.wurlod]

There is no IsValid() function (unless you've written one) in server jobs.