DB2 Timestamp Value

[etan1999]

Hi.

I have a table with a column defined as TIMESTAMP.

Is it possible to insert a value into this column, using
a variable PIC X(26) containing a value in DB2 format "YYYY-MM-DD-HH.MM.SS.ssssss" ?

Thanks.

 

[Crox]

Part of the referenceguide:

 TIMESTAMP


 A string of length 26, enclosed in single
 quotation marks. The string has the format
 yyyy-mm-dd-hh.mm.ss.nnnnnn.

    _____________________________________________________________________________________________
   | Table 6. Declarations generated by DCLGEN                                                   |
   |________________________ ____________________ _____________________________ _________________|
   | SQL Data Type(6)       | C                  | COBOL                       | PL/I            |
   |________________________|____________________|_____________________________|_________________|

...

   | TIMESTAMP              | char var[27]       | PIC X(26)                   | CHAR(26)        |
   |________________________|____________________|_____________________________|_________________|


[\CODE]

 

[gregsimpson]

looks okay to me.

Cheers
Greg