I’m trying to set two Date columns in one table with Default values. When using the Table Design View GUI, I enter the default values I want and save the changes then save the database. When I edit the table and click on the DATE “Field Types” I do not see the values I previously set. If I click back and forth between the two fields, the DEFAULT values change on each click. I have no confidence they are being set to the values I want.
I tried the query: SELECT * FROM “INFORMATION_SCHEMA”.“SYSTEM_COLUMNS” WHERE “TABLE_SCHEM” = ‘PUBLIC’
To try and see what the two column DEFAULT Date values were and I don’t see a column that I interpret as to what would be the DEFAULT.
Am I way out in left field? Is this something I shouldn’t worry about but just trust the GUI?
If there is a way to set then view what the DEFAULT Date values are with queries, would someone offer suggestion(s) on what query to use, please?
I’m using default HSQLDB.
Thank you in advance!