>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.
