unable to insert data and time values into table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

narayana - 22 May 2006 21:29 GMT

hi gurus,
I am kid at DB2 .problem is I am unable to insert values of time and
date datatype fields into tables .default date datatype is taking
4bytes lenght so I am unable to insert date value into it .Is there any
way or else I have to do any modifications to my table. plz give some
hint.

Reply to this Message

Jack Miller - 22 May 2006 22:16 GMT

What query are you typing and which mechanism are you using to connect
to the database (ODBC, JDBC or other)

> hi gurus,
> I am kid at DB2 .problem is I am unable to insert values of time and
> date datatype fields into tables .default date datatype is taking
> 4bytes lenght so I am unable to insert date value into it .Is there any
> way or else I have to do any modifications to my table. plz give some
> hint.

Reply to this Message

narayana - 23 May 2006 13:52 GMT

I am using jdbc .db2 clp it working fine but where as from control
center I am unable to insert date and time values to that table.

Reply to this Message

rAinDeEr - 23 May 2006 15:16 GMT

hi ,

insert date as '2006-05-20'

rainDeeR

Reply to this Message

rAinDeEr - 23 May 2006 15:20 GMT

Hi,

I created a table with time and date and i was able to insert values.

Insert into tariq.test values('12.02.35','2006-05-20')
Hope this helps....

Regards,
RaiNdEeR

Reply to this Message