As per my knowledge,
CLOCK_TIMESTAMP value changes every time you call it even in the same transaction
BEGIN
...
CLOCK_TIMESTAMP() -- Gives 2017-11-23 15:02:27.492867+05:30
...
...
CLOCK_TIMESTAMP() -- Gives different time as per current clock time
...
END;
CURRENT_TIMESTAMP
is the time of
start of current transaction and does not change in the same transaction.
BEGIN
...
CURRENT_TIMESTAMP() -- Gives 2017-11-23 15:01:40.171462+05:30
...
...
CURRENT_TIMESTAMP() -- Gives same time as previous call
...
END;
-- Murtuza
On Thu, Nov 23, 2017 at 2:29 PM, Brahmam Eswar <brahmam1234@xxxxxxxxx> wrote:
What is difference between CLOCK_TIMESTAMP() and CURRENT_TIMESTAMP?Is there any specific use case to differentiate them .--Thanks & Regards,
Brahmeswara Rao J.
