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> |