Thread: Timestamp

Timestamp

From
Postgres Sql - CTI
Date:
    Hi all,

    I'd like know how can I change a timestamp field's value starting
from the "current_timestamp" value. My objective is to calculate a time
interval.

    I was trying to do something like this:

- insert into logs values ('login', 'session', current_timestamp);

    But, I don't want to include the <current> date and time. Before
including data into the table, I'd like to plus 10 minutes in
current_timestamp.

    Thanks for any help.

Luiz


Re: [GENERAL] Timestamp

From
Gregory Maxwell
Date:
Something like ('now'::datetime + '10 min'::timespan) might work..

On Wed, 17 Mar 1999, Postgres Sql - CTI wrote:

>
>     Hi all,
>
>     I'd like know how can I change a timestamp field's value starting
> from the "current_timestamp" value. My objective is to calculate a time
> interval.
>
>     I was trying to do something like this:
>
> - insert into logs values ('login', 'session', current_timestamp);
>
>     But, I don't want to include the <current> date and time. Before
> including data into the table, I'd like to plus 10 minutes in
> current_timestamp.
>
>     Thanks for any help.
>
> Luiz
>
>