DROP TABLE T1 IF EXISTS;
//CREATE TABLE T1(ID IDENTITY, DT DATE DEFAULT CURRENT_DATE,TI TIME DEFAULT CURRENT_TIME,TS TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
CREATE TABLE T1(ID IDENTITY, DT DATE,TI TIME,TS TIMESTAMP);
INSERT INTO T1 (ID, DT, TI, TS) VALUES (NULL, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP);
SELECT DAYOFMONTH(DT) FROM T1;
//SELECT DAYOFMONTH(TI) FROM T1;
SELECT DAYOFMONTH(TS) FROM T1;
DROP TABLE T1
