Java – how to create a specific date in HSQLDB?

I need to create a high date in HSQLDB. The solution does not include me I need something similar

Date(9999-12-31 0:0:0)

But I can't find a function or do anything I gave up the date through spring at startup. I need something like this:

insert intoMOD (
  ITM_INST_ELECTR_MOD_STRT_TS,ITM_INST_ID,ELECTR_MOD_ID,ITM_INST_ELECTR_MOD_END_TS
) VALUES (
  CURRENT_DATE,Date(9999-12-31 0:0:0)
)

What is the method of using SQL to create specific data in hypersonic?

Solution

Given the user guide, I look forward to the following:

DATE '9999-12-31'

Or, if you need to exceed daily precision:

TIMESTAMP '9999-12-31 00:00:00'
The content of this article comes from the network collection of netizens. It is used as a learning reference. The copyright belongs to the original author.
THE END
分享
二维码
< <上一篇
下一篇>>