Re: Tiiiiiiiiiiiiime

From: Ryan Mahoney <ryan(at)paymentalliance(dot)net>
To: "hiroko" <h_ogawa(at)rnk(dot)co(dot)jp>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Tiiiiiiiiiiiiime
Date: 2001-05-16 20:36:12
Message-ID: 5.0.2.1.0.20010516213355.0269e0b0@paymentalliance.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This is a guess - have you tried:

SELECT * FROM tableName WHERE time = CURRENT_TIMESTAMP - '3 months'::interval

let me know if it works!

-r

At 05:49 PM 5/15/01 +0900, hiroko wrote:

>hi all.
>
>from a DB table, I'd like to SELECT out the date of 3months before.
>the command should be
>
>=> select * from MYTBL where time =XXXXXX ;
>
>what whould it like to be at XXXXX ?
>I thought that I can use the type of 'today', which is meant to be the
>0:00am of the day.
>or 'current' or things like this. but how can you make it "0:00am of three
>days ago"?
>
>also, if you know about it,
>I'd like to know about the difference between 'current' and 'now'.
>
>thanks about that.
>
>hiroko ogawa
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com)
>Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01

Attachment Content-Type Size
unknown_filename text/plain 166 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Howansky 2001-05-16 20:43:32 Re: Restore from a dead machine.
Previous Message Joel Burton 2001-05-16 20:03:50 Re: sql question