Differences

This shows you the differences between two versions of the page.

Link to this comparison view

dev:sql:functions:current_date [2010/07/28 22:19]
els
dev:sql:functions:current_date [2016/06/28 22:38]
Line 1: Line 1:
-{{page>:​top_add&​nofooter&​noeditbtn}} 
-{{page>:​sql_bar&​nofooter&​noeditbtn}} 
- 
-====== Omnidex SQL Function: CURRENT_DATE ====== 
-===== Description ===== 
-The CURRENT_DATE function returns the current date from the server'​s time-of-day clock. ​ The function is processed once at the beginning of the execution of the SQL statement. ​ A new value is not obtained with each reference or with each fetched row.  In a client-server or Omnidex Grid application,​ the date returned is from the individual server processing the query. 
- 
-This function returns an ANSI DATE datatype. 
-===== Syntax ===== 
-CURRENT_DATE 
- 
-===== Examples ===== 
-==== Example 1: Column ==== 
-<​code>​ 
-> select current_date from $omnidex; 
- 
-CURRENT_DATE 
------------- 
-  2010-07-28 
- 
-</​code>​ 
-==== Example 2: Expression calculating age ==== 
- 
-<​code>​ 
-> select birthdate, $compare_dates(birthdate,​ current_date,​ '​YY'​) age from individuals;​ 
- 
-BIRTHDATE ​    AGE 
------------- ​ ----------- 
-  1938-07-14 ​          72 
-  1957-11-22 ​          53 
-  1960-07-28 ​          50 
-  1929-08-22 ​          81 
-  1933-07-09 ​          77 
-  1944-08-01 ​          66 
-  2004-09-14 ​           6 
-</​code>​ 
- 
-====== Additional Resources ====== 
- 
-See also: 
-{{page>​dev:​sql:​functions:​see_also_variables&​nofooter&​noeditbtn&​noheader}} 
- 
-{{page>:​bottom_add&​nofooter&​noeditbtn}} 
- 
  
 
Back to top
dev/sql/functions/current_date.txt ยท Last modified: 2016/06/28 22:38 (external edit)