TPT - TIMESTAMP FORMAT - century of '19' instead of '20'

Database
Junior Supporter

TPT - TIMESTAMP FORMAT - century of '19' instead of '20'

My data:
15-MAR-11 07.54.08.000000 AM
15-MAR-11 07.53.40.000000 AM
15-MAR-11 07.53.04.000000 AM
15-MAR-11 07.52.55.000000 AM
15-MAR-11 07.52.16.000000 AM

My current DDL:
CREATE multiset TABLE dbname.dbtable
(
CREATE_DATE timestamp(6)
);

My current TPT Insert statement:
'INSERT INTO '||@TargetDatabase||'.dbtable
(
CREATE_DATE = :CREATE_DATE (TIMESTAMP, FORMAT ''DD-MMM-YYBHH.MI.SS.S(6)BT'')
);'

The data is being stored in the database table with century of '19' instead of '20'. My data will always be century of '20':

CREATE_DATE
1911-03-15 07:54:08
1911-03-15 07:53:40
1911-03-15 07:53:04
1911-03-15 07:52:55
1911-03-15 07:52:16

Anyone know how I can force '20' to be the century instead of '19'?
1 REPLY
Junior Contributor

Re: TPT - TIMESTAMP FORMAT - century of '19' instead of '20'

Reminds me of "year 2k" :-)

There's only a global setting (dbscontrol global field 14: CenturyBreak), but no session local setting.

Why don't you simply concat '20' to the timestamp and change the format accordingly?

Dieter