This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:functions:calc_date [2010/07/27 17:43] els |
dev:sql:functions:calc_date [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | {{page>:sql_bar&nofooter&noeditbtn}} | + | ====== Development: Omnidex SQL ====== |
| - | ====== Omnidex SQL Function: $CALC_DATE ====== | + | |
| - | ===== Description ===== | + | ===== SQL Functions: $CALC_DATE ====== |
| + | |||
| + | ==== Description ==== | ||
| The $CALC_DATE function performs arithmetic on a date expression, returning a new date value. The arithmetic is performed using the units declared in the function, or using DAYS if not specified. | The $CALC_DATE function performs arithmetic on a date expression, returning a new date value. The arithmetic is performed using the units declared in the function, or using DAYS if not specified. | ||
| This function returns the same datatype as the passed date expression. | This function returns the same datatype as the passed date expression. | ||
| - | ===== Syntax ===== | + | ==== Syntax ==== |
| $CALC_DATE( date_expression, numeric_expression [ , date_token ] ) | $CALC_DATE( date_expression, numeric_expression [ , date_token ] ) | ||
| Line 33: | Line 35: | ||
| - | ===== Example ===== | + | ==== Example ==== |
| - | ==== Example 1: $CALC_DATE adding 18 years ==== | + | === Example 1: $CALC_DATE adding 18 years === |
| <code> | <code> | ||