Re: [GENERAL] Timestamp

From: Gregory Maxwell <greg(at)z(dot)ml(dot)org>
To: Postgres Sql - CTI <pgsqlcti(at)vetnet2(dot)vetorialnet(dot)com(dot)br>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Timestamp
Date: 1999-03-19 03:21:56
Message-ID: Pine.LNX.3.96.990318222122.14241A-100000@z.ml.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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
>
>

In response to

  • Timestamp at 1999-03-17 17:23:03 from Postgres Sql - CTI

Browse pgsql-general by date

  From Date Subject
Next Message Peter Blazso 1999-03-19 06:40:29 subscribe pgsql-general
Previous Message Jonathan A. Zdziarski 1999-03-18 21:57:24 Database access permissions