Re: Is there a name for date format used by DB2?

On Fri, Oct 16, 2015 at 5:14 PM James H. H. Lampert <
jamesl@xxxxxxxxxxxxxxxxx> wrote:

Maybe SAA Timestamp?

Ok google takes me right to the IBM docs. What does SAA stand for? The
society of American Archivist doesn't seem to recommend that date format.
http://www2.archivists.org/standards/DACS/part_I/chapter_2/4_date

I am only being partial facetious because that's literally the closest I
could come to a reasonable expansion of SAA.

However, now that I found that page, which indicates that I could at least
accomplish this in MI. Is there a SQL scalar function that will take a
string in ISO 8601 format as input and output a TIMESTAMP column? Until I
submit a patch to PHP, it might be easier to just write the conversion into
the INSERT statement.