Inserting a date into db2

How can I insert a date into db2 in开发者_如何转开发 this format: yyyy-mm-dd, using a sql query?

---

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