Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi

  • for firebird: SELECT "Date", DATEADD (10 day to "Date") "Date+10" FROM "Table"
  • for Hsqldb: SELECT "Date", DATEDIFF( 'DD', '1899-12-30', "Date" ) + 10 AS "Date+NbJours" FROM "Table"

Regards

Hi

  • for firebird: SELECT "Date", DATEADD (10 day to "Date") "Date+10" FROM "Table"
  • for Hsqldb: SELECT "Date", DATEDIFF( 'DD', '1899-12-30', "Date" ) + 10 AS "Date+NbJours" "Date+10" FROM "Table"

Regards

Hi

[EDIT]

The syntax to calculate the addition of a number of days:

  • for firebird: SELECT "Date", DATEADD (10 day to "Date") "Date+10" FROM "Table"
  • for Hsqldb: SELECT "Date", DATEDIFF( 'DD', '1899-12-30', "Date" ) + 10 "Date+10" FROM "Table"

Syntax applied to select with Hsqldb:

SELECT "Date" FROM "Table" WHERE
DATEDIFF( 'DD', '1899-12-30', "Date" ) >=  DATEDIFF( 'DD', '1899-12-30', CURRENT_DATE ) 
AND
DATEDIFF( 'DD', '1899-12-30', "Date" ) <=  DATEDIFF( 'DD', '1899-12-30', CURRENT_DATE ) + 10

Regards