Timestamp
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
Something like ('now'::datetime + '10 min'::timespan) might work..
On Wed, 17 Mar 1999, Postgres Sql - CTI wrote:
Show quoted text
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