Data type

yash2400 · #1 (**permalink**) 08-24-08, 22:08

Hi All,

Please suggest me, what data type should I type for timeframe col. I've tried time, date, timestamp. None of these worked. It keep saying "SQL0180N The syntax of the string representation of a datetime value is
incorrect. SQLSTATE=22007 ". Any suggestion would really help.

Marcus_A · #2 (**permalink**) 08-24-08, 22:17

Need more information about what you are trying to store in the column.

tonkuma · #3 (**permalink**) 08-24-08, 22:22

What data did you specified for that column?
DB2 accepts
'yyyy-mm-dd', 'mm/dd/yyyy', or 'dd.mm.yyyy' for DATE,
'yyyy-mm-dd-hh.mm.ss.nnnnnn' or 'yyyy-mm-dd hh:mm:ss.nnnnnn' for TIMWSTAMP.
Please see "String representations of datetime values" in "DB2 SQL Reference Volume 1" for more descriptions.

yash2400 · #4 (**permalink**) 08-24-08, 22:28

I am trying to insert "current date" in that column. The column supposed to be "timeframe". I'hv tried all three data type (date, time, timestamp). Nothing is working. It gives error msg the target data is greater than the column specified.

I am using Db2 V 8.2
Fixpak 10

tonkuma · #5 (**permalink**) 08-25-08, 01:50

Code:

------------------------------ Commands Entered ------------------------------
CREATE TABLE Test_date_time_format
(id INTEGER
,timeframe1 DATE
,timeframe2 TIME
,timeframe3 TIMESTAMP
);
------------------------------------------------------------------------------
DB20000I  The SQL command completed successfully.

------------------------------ Commands Entered ------------------------------
INSERT INTO Test_date_time_format
 VALUES (1, current date, current time, current timestamp);
------------------------------------------------------------------------------
DB20000I  The SQL command completed successfully.

------------------------------ Commands Entered ------------------------------
SELECT * FROM Test_date_time_format;
------------------------------------------------------------------------------

ID          TIMEFRAME1 TIMEFRAME2 TIMEFRAME3                
----------- ---------- ---------- --------------------------
          1 2008-08-25 14:49:38   2008-08-25-14.49.38.339000

  1 record(s) selected.

Internet Services

Web Development

Digital Marketing

Consumer Tech