This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
current-timestamp [2015/09/23 20:27] 127.0.0.1 external edit |
current-timestamp [2015/11/10 10:55] dmtolpeko |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== CURRENT_TIMESTAMP Function - PL/HQL ====== | + | ====== CURRENT_TIMESTAMP Function ====== |
CURRENT_TIMESTAMP function returns the current date and time (year, month, day, hour, minute, seconds and fractional seconds). | CURRENT_TIMESTAMP function returns the current date and time (year, month, day, hour, minute, seconds and fractional seconds). | ||
Line 28: | Line 28: | ||
</code> | </code> | ||
- | **Compatibility**: IBM DB2. | + | **Compatibility**: Oracle, IBM DB2, Teradata, MySQL. |
- | **Version:** PL/HQL 0.03 | + | **Version:** HPL/SQL 0.1 |
See also: | See also: | ||
* [[current-date|CURRENT_DATE]] | * [[current-date|CURRENT_DATE]] | ||
+ | * [[from-unixtime|FROM_UNIXTIME]] | ||
+ | * [[now|NOW]] | ||
* [[sysdate|SYSDATE]] | * [[sysdate|SYSDATE]] | ||
+ | * [[unix-timestamp|UNIX_TIMESTAMP]] |