Differences

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

Link to this comparison view

dev:sql:functions:current_timestamp [2010/07/28 22:24]
els
dev:sql:functions:current_timestamp [2016/06/28 22:38]
Line 1: Line 1:
-{{page>:​top_add&​nofooter&​noeditbtn}} 
-{{page>:​sql_bar&​nofooter&​noeditbtn}} 
- 
-====== Omnidex SQL Function: CURRENT_TIMESTAMP ====== 
-===== Description ===== 
-The CURRENT_TIMESTAMP function returns the current timestamp 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 timestamp returned is from the individual server processing the query. 
- 
-This function returns an ANSI DATETIME datatype. 
-===== Syntax ===== 
-CURRENT_TIMESTAMP 
- 
-===== Examples ===== 
-==== Example 1: Column ==== 
-<​code>​ 
-> select current_timestamp from $omnidex; 
- 
-CURRENT_TIMESTAMP 
----------------------- 
-2010-07-28 16:23:19.00 
- 
-</​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_timestamp.txt ยท Last modified: 2016/06/28 22:38 (external edit)