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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Margarit Nickolov <man(at)developer(dot)digsys(dot)bg>
Cc: The Hermit Hacker <scrappy(at)hub(dot)org>, pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] adding time to a datetime field ... how?
Date: 1999-12-17 00:31:01
Message-ID: Pine.LNX.4.21.9912161925010.5199-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Howie 1999-12-17 08:18:00 Re:[OT]-[SQL] manually set serial type
Previous Message kaiq 1999-12-16 19:22:32 Re: [SQL] manually set serial type