Re: GENERATE AS

[Ron <ronljohnsonjr@xxxxxxxxx>]

    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.