How do I create a specific date in HSQLDB?

Question

I need to create a HIGH date in HSQLDB and the solution is eluding me. I need something like ``` Date(9999-12-31 0:0:0) ``` but I cannot find a function or whatever to do it. I am loding the date via Spring on startup and i need something like: ``` insert intoMOD ( ITM_INST_ELECTR_MOD_STRT_TS, ITM_INST_ID, ELECTR_MOD_ID, ITM_INST_ELECTR_MOD_END_TS ) VALUES ( CURRENT_DATE, 0, 0, Date(9999-12-31 0:0:0) ) ``` What is the way to create a specific data using SQL in Hypersonic?

Accepted Answer

Given the user guide, I'd expect the following to work:

```
DATE '9999-12-31'
```

or, if you need more than day precision:

```
TIMESTAMP '9999-12-31 00:00:00'
```

How do I create a specific date in HSQLDB?

Solution

Problem