Re: [SQL] adding time to a datetime field ... how?

From: Vladimir Terziev <vlady(at)school(dot)digsys(dot)bg>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] adding time to a datetime field ... how?
Date: 1999-12-15 16:21:11
Message-ID: Pine.BSI.4.20.9912151817320.2203-100000@school.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Try

select start_time,
abstime_datetime(start_time::abstime + acctsessiontime)
from log;

Regards!

Vladimir

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-12-15 16:28:15 Re: [SQL] numbered table?
Previous Message Margarit Nickolov 1999-12-15 14:01:32 Re: [SQL] adding time to a datetime field ... how?