Skip to content

Tag: date-arithmetic

SQL – Inster into with now() minus one day

I want change this request. Actualy this request insert into always 2021-11-11 at 10:50:00 I use a script.sql for my H2 database (continous delivery). I want change my request to Now() minus one day at 10:50:00. Answer Subtract a day from the current date, then add the time.

sql get balance at end of year

I have a transactions table for a single year with the amount indicating the debit transaction if the value is negative or credit transaction values are positive. Now in a given month if the number of debit records is less than 3 or if the sum of debits for a month is less than 100 then I want to charge