Date and Timestamp in DB2

ThomBFG · #1 (**permalink**) 08-16-04, 13:41

Hello,

I've got 2 questions concerning timestamp and date. I need to make an insert in a table where there is one column of type Date and one colum in type Timestamp.
First I wanted know if the column of type timestamp is automaticaly filled, if not how do I do it?
Second I don't know the appropriate function for inserting a date (as TO_DATE with Oracle) ?

Thanks very much for your help, I am really begining with DB2...

Thom

sathyaram_s · #2 (**permalink**) 08-16-04, 13:56

You will have to define the column to have a default value if you intend to 'auto-populate' it ..

I can't comment on TO_DATE because I am not sure what it does ...

BTW, please read 'Must read Before Posting' thread ...

Cheers
Sathyaram

AStefan · #3 (**permalink**) 08-17-04, 03:35

You can use cast instead of to_date.
It works on sql server, oracle and db2 too.

n_i · #4 (**permalink**) 08-17-04, 11:35

Quote:

Originally Posted by AStefan

You can use cast instead of to_date.
It works on sql server, oracle and db2 too.

You don't need to explicitly cast to DATE; it will happen automatically if you supply a properly formatted string, e.g.

Code:

create table test ( mydate date );
insert into test (mydate) values ('2004-08-17');

assuming the client uses ISO date format.

Internet Services

Web Development

Digital Marketing

Consumer Tech