Differences

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

--- dev:sql:functions:current_timestamp [2009/12/05 00:15]
tdo created
+++ dev:sql:functions:current_timestamp [2016/06/28 22:38] (current)
@@ Line 1: / Line 1: @@
 {{page>:top_add&nofooter&noeditbtn}}
-<html><div align="center"><span style="color:red">DRAFT</span></div></html>
-====== Omnidex SQL Function: CURRENT_TIMESTAMP ======
 {{page>:sql_bar&nofooter&noeditbtn}}
+====== Omnidex SQL Function: CURRENT_TIMESTAMP ======
 ===== Description =====
-The CURRENT_TIMESTAMP function returns the current timestamp from the system's time-of-day clock.
+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.
-The function is processed once at the beginning of execution of the SQL statement. A new value is not obtained with each reference or with each fetched row.
+This function returns an ANSI DATETIME datatype.
 ===== Syntax =====
-  CURRENT_TIMESTAMP
+CURRENT_TIMESTAMP
-===== Example =====
-==== Example 1 ====
-<code SQL>
-elect company,
-current_timestamp
-from customers
-where company='dynamic'
-...
+===== Examples =====
-Dynamic Information Systems Corporation, 2003-01-24 14:45:04.00
+==== Example 1: Column ====
+<code>
+> select current_timestamp from $omnidex;
+CURRENT_TIMESTAMP
+----------------------
+-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.1259972139.txt.gz · Last modified: 2016/06/28 22:38 (external edit)

Sitemap Recent Changes