Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] adding time to a datetime field ... how? - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: [SQL] adding time to a datetime field ... how?
Date
Msg-id Pine.LNX.4.21.9912161925010.5199-100000@localhost.localdomain
Whole thread Raw
In response to Re: [SQL] adding time to a datetime field ... how?  (Margarit Nickolov <man@developer.digsys.bg>)
Responses Re: [SQL] adding time to a datetime field ... how?  (Margarit Nickolov <man@digsys.bg>)
List pgsql-sql
Tree view 
On 1999-12-15, Margarit Nickolov mentioned:

> select start_time,start_time+acctsessiontime::timespan from log;

Wow, that is really weird. I would consider it confusing behaviour at
best if an explicit cast interprets an int as seconds whereas an implicit
conversion thinks it's days.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

pgsql-sql by date:

Previous
From: rob caSSon
Date:
Subject: Re:[OT]-[SQL] manually set serial type
Next
From: Howie
Date:
Subject: Re:[OT]-[SQL] manually set serial type