Re: [GENERAL] Date Time data types

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(at)gmail(dot)com>
wrote:

> What is difference between CLOCK_TIMESTAMP() and CURRENT_TIMESTAMP?
>
> Is there any specific use case to differentiate them .
> --
> Thanks & Regards,
> Brahmeswara Rao J.
>