SQLサンプル - ＠WIKI

--Sql サンプル
 
SELECT
    entry_date,
    CHAR(REPLACE(CHAR(CURRENT DATE  - 4 MONTHS),'-','') || REPLACE(CHAR(CURRENT TIME),'.','')) AS sysdate,
    CHAR(CURRENT DATE  - 4 MONTHS) AS nowdate,
    CHAR(CURRENT TIME) AS nowtime
FROM
   test_a
WHERE
    entry_date <= CHAR(REPLACE(CHAR(CURRENT DATE  - 4 MONTHS),'-','') || REPLACE(CHAR(CURRENT TIME),'.',''));