loading a timestamp

Serge Rielau · *nix forums Guru Joined: 29 Apr 2005 Posts: 1583

JS wrote:

Tonkuma · *nix forums Guru Wannabe Joined: 07 Jun 2005 Posts: 178

One idea is to load the timestamp as chars. Then reformat and put it
into timestamp column using TO_DATE UDF in "Sample UDFs for Migration"
http://www-106.ibm.com/developerworks/db2/library/samples/db2/0205udfs/index.html

fyi85@hotmail.com · *nix forums beginner Joined: 08 Jun 2005 Posts: 19

I have a del file with timestamp format as: Jan 1 1995 12:00AM
I am trying to load this as:
modified by timestampformat "MMM/D/YYYY HH:MM TT"
but DB2 will not accept it. I have tried various combinations of the
modifier but no luck so far. Does anybody know the correct syntax to
load this value?
Many thanks if you do

Google