Timestamp

From: Postgres Sql - CTI <pgsqlcti(at)vetnet2(dot)vetorialnet(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Timestamp
Date: 1999-03-17 17:23:03
Message-ID: Pine.LNX.4.02.9903171709050.24149-100000@vetnet2.vetorialnet.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan A. Zdziarski 1999-03-17 18:00:14 Creating Users
Previous Message The Hermit Hacker 1999-03-17 17:06:13 Any news admins...