HSQLDB example source code file (TestSelfConversions.txt)

This example HSQLDB source code file (TestSelfConversions.txt) is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" ^TM.

Java - HSQLDB tags/keywords

current_date, dayofmonth, drop, drop, dt, dt, exists, from, id, select, t1, t1, table, table

The HSQLDB TestSelfConversions.txt source code

DROP TABLE T1 IF EXISTS;
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(TS) FROM T1;
DROP TABLE T1