Timeline for Difference between now() and current_timestamp
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 12, 2020 at 16:05 | comment | added | Daniel W. | This answer is confusing opposed to the other answer, especially with the quotes. | |
| Feb 2, 2018 at 2:04 | comment | added | Erwin Brandstetter | This is a misunderstanding. The input string 'now()' looks similar to the function now() on the surface, but is not directly related otherwise. 'now' is a constant evaluating to the current transaction's start time. Trailing parens are ignored. The attempt to cast the strings 'CURRENT_TIMESTAMP' or 'transaction_timestamp()' to timestamp in similar fashion fails, because that's just nonsense. Neither is related to the corresponding functions. | |
| Dec 9, 2016 at 16:49 | history | answered | Vao Tsun | CC BY-SA 3.0 |