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.

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


narayana wrote:[color=blue]
> 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.
>[/color]

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.

hi ,

insert date as '2006-05-20'

rainDeeR

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