Inserting a date into db2

Question

How can I insert a date into db2 in this format: yyyy-mm-dd, using a sql query?

Answer 1

Consider a table:

CREATE TABLE tab (dt DATE);

Now insert a date into it as:

INSERT INTO tab VALUES ('2010-12-31');

Now on doing

SELECT * from tab; 

we get:

DT
2010-12-31