TIMESTAMPDIFF

 

The function TIMESTAMPDIFF returns a new timestamp value based on adding an interval to an existing timestamp value.

SQL Syntax:
 
   TIMESTAMPADD (interval, timestamp1, timestamp2)
Interval:
 
  One of the follow constants SQL_TSI_FRAC_SECOND,
SQL_TSI_SECOND, SQL_TSI_MINUTE,
SQL_TSI_HOUR, SQL_TSI_DAY, SQL_TSI_WEEK,
SQL_TSI_MONTH, SQL_TSI_QUARTER, or
SQL_TSI_YEAR
 
timestamp1, timestamp2:
 
  A timestamp expression.
Escape Syntax:
 
  {fn TIMESTAMPDIFF (interval, timestamp1, timestamp2)}
Return Type:
 
  INT
Alternative Function Names:
 
  DATEDIFF: This is the equivalent from the MS SQL Server.
Alternative Interval Names:   Year yy, yyyy
quarter qq, q
Month mm, m
dayofyear dy, y
Day dd, d
Week wk, ww
Hour hh
minute mi, n
second ss, s
millisecond ms

Examples:

  • SELECT timestampadd(SQL_TSI_DAY, mydate, now()) from mytable

see also:
SQL Date Time Functions


100% pure Java DBMS
Mirror Site