This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:functions:current_timestamp [2010/07/28 22:23] els |
dev:sql:functions:current_timestamp [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 6: | Line 6: | ||
| 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 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 DATE datatype. | + | This function returns an ANSI DATETIME datatype. |
| ===== Syntax ===== | ===== Syntax ===== | ||
| CURRENT_TIMESTAMP | CURRENT_TIMESTAMP | ||