Re: [h2] Problems with DATEADD, DATEDIFF and daylight savings time

Hello! I have tests that use a H2 db, and the data set is populated with timestamps relative to the current timestamp, using expressions such as DATEADD(DAY, -3, CURRENT_TIMESTAMP). Let's say current timestamp is 2023-03-27 18:00:00 CURRENT_TIMESTAMP can't return this value, it returns a TI

Re: [h2] Problems with DATEADD, DATEDIFF and daylight savings time

Hello, I encountered a similar issue today, after France switched to daylight savings time yesterday, and I was only using DATEADD, not DATEDIFF. I have tests that use a H2 db, and the data set is populated with timestamps relative to the current timestamp, using expressions such as DATEADD(DA

[h2] Need help in diagnosing the db file

Driver Class: org.h2.Driver JDBC URL: jdbc:h2:./weighdata User Name: root Password: toor h2 version : h2-2.1.214 if we open and close the db file in backup it with crash the db file -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe

[h2] When i open and close this db file i gives me File corrupted error

driver class org.h2.Driver url : jdbc:h2:./weighdata username root password :toor h2 version jar : h2-2.1.214 If you open the file and close it the file will get corrupted can some one help me diagnoy y its happenening. -- You received this message because you are subscribed to the Google Grou