Hello all -

Happy Friday!

I've got a table of VARCHARs. One field is really a timestamp, but ALTER
TABLE to change the datatype appears to nullify the data. I'd like to
SELECT it as a timestamp and then do a SELECT-INSERT to another table
that's properly formatted already, but I'm confused about the syntax.
Why won't ...

SELECT TIMESTAMP_FORMAT(FIELD_2)
FROM PRE2005CR

...work? And example string looks like this '10/1/1996 0:15:00'. I've
poured over the 'Fun with Dates and Times' page, but I'm not finding it
that fun at the moment! =)

TIA


DB2 & UDB email list listserv db2-l LazyDBA home page