ANOTHER IT CO

A Few Notes About Handling Dates

Following are some things I have learned about handling dates:

When passing dates to the Pivot Stage, they should be in internal format.
When passing dates to the Informix CLI Stage, they should be in internal format.
Dates and timestamps to and from the ODBC stage should be in external format, YYYY-MM-DD or YYYY-MM-DD hh:mm:ss.sss respectively.

If you have any additions for this page, email them to me at chuck@anotheritco.com