Re: another problem with pgsql and interva/timestamp

From: "Fernando Papa" <fpapa(at)claxson(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: another problem with pgsql and interva/timestamp
Date: 2003-03-21 22:30:20
Message-ID: F1DC5B511E2D1C499E5E20FC6D74160D01D6D7E0@exch2000.buehuergo.corp.claxson.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Thanks again Tom...
select now() + 33 * interval '1 day';

works perfect!

--
Fernando O. Papa
DBA

> -----Mensaje original-----
> De: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Enviado el: viernes, 21 de marzo de 2003 16:31
> Para: Fernando Papa
> CC: pgsql-general(at)postgresql(dot)org
> Asunto: Re: [GENERAL] another problem with pgsql and
> interva/timestamp
>
>
> "Fernando Papa" <fpapa(at)claxson(dot)com> writes:
> > Now, I'm trying to add a numer of days to a date.
>
> > If I do this:
> > select now() + interval '2 day'
>
> Do you actually want a datetime result, or just a date? If
> the desired result is a date, you'd find it a lot easier to
> use the date-plus-integer operator:
>
> regression=# select current_date;
> date
> ------------
> 2003-03-21
> (1 row)
>
> regression=# select current_date + 4;
> ?column?
> ------------
> 2003-03-25
> (1 row)
>
> If you do really need sub-day resolution, then stick to
> timestamp plus interval.
>
> > I get a datetime two days in the future, thats ok. I want
> to do this,
> > but I have these "2" into a variable inside pl/pgsql.
>
> If you've got a numeric variable, the easiest way to convert
> it to an interval is to use the float-times-interval operator:
>
> regression=# select 33 * interval '1 day';
> ?column?
> ----------
> 33 days
> (1 row)
>
> regression=# select now() + 33 * interval '1 day';
> ?column?
> -------------------------------
> 2003-04-23 15:29:12.592024-04
> (1 row)
>
> No need to fool with insertion of text into an interval literal ...
>
> regards, tom lane
>

Browse pgsql-general by date

  From Date Subject
Next Message P G 2003-03-21 23:17:31 Which files does PostgreSQL need from initscripts RPM?
Previous Message Mr. why? 2003-03-21 22:28:15 Expanded display (\x) seems to affect display of latin1 chars