On 6/22/23 15:00, Wetmore, Matthew (CTR) wrote:
>
> Hi, I have this issue and now I’m just wasting time. Can you tell me what
> I’m doing wrong?
>
> I’d like to subtract a column timestamp hour from current hour to give me
> hours elapased.
>
> How do I do this easily?
>
> I think I’ve tried every combination of types and casting.
>
> Thanks in advance.
>
> ---------------------------
>
> 1. ALTER TABLE matt
>
> add column matt_time timestamp with time zone default
> current_timestamp;
>
Besides what Ilya and David mentioned, CURRENT_TIMESTAMP is based on when
the transaction started. You might have wanted clock_timestamp().
--
Born in Arizona, moved to Babylonia.