public inbox for [email protected]  

help / color / mirror / Atom feed

From: Stephan Szabo <[email protected]>
To: CSN <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: [GENERAL] Suggestion for Date/Time Functions Section
Date: Fri, 19 Aug 2005 22:44:30 -0700 (PDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>


On Fri, 19 Aug 2005, CSN wrote:

> Hi,
>
> I suggestion for the date/time functions in the docs:
> http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html
>
> I was trying to figure out how to do:
> update table set next=now() + interval 'table.period
> seconds';
>
> I tried subqueries, the concat operator, and anything
> else I could think of until I rediscovered the page on
> the various ways to cast. Perhaps mix up the examples
> in the docs so other ways to do date arithmetic (and
> that allow expressions, fields, etc.) are obvious:
>
> date '2001-09-28' + cast((7+7)||' seconds' as
> interval);

I'd suggest something like
 date '2001-09-28' + (7+7) * interval '1 second';
instead of using text concatenation.

view thread (3+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: [GENERAL] Suggestion for Date/Time Functions Section
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox