Tiiiiiiiiiiiiime

From: "hiroko" <h_ogawa(at)rnk(dot)co(dot)jp>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Tiiiiiiiiiiiiime
Date: 2001-05-15 08:49:36
Message-ID: 001901c0dd1c$0ab91b60$e801a8c0@d4.dion.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message u966918945 2001-05-15 09:29:41 psql dies on select *
Previous Message Lincoln Yeoh 2001-05-15 08:20:20 index ops for _int4 and trees?