>What is difference between CLOCK_TIMESTAMP() and CURRENT_TIMESTAMP?
CURRENT_TIMESTAMP stays the same within the transaction. It is very useful when you
are you inserting to multiple tables and want to use the timestamp columns to chain the rows
together.
CLOCK_TIMESTAMP is the true timestamp at that given instant. Useful for debugging
purposes. I hardly see a use of it in applications, for reasons mentioned above.