Tiiiiiiiiiiiiime - Mailing list pgsql-general

From hiroko
Subject Tiiiiiiiiiiiiime
Date
Msg-id 001901c0dd1c$0ab91b60$e801a8c0@d4.dion.ne.jp
Whole thread Raw
Responses Re: Tiiiiiiiiiiiiime  (Ryan Mahoney <ryan@paymentalliance.net>)
List 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
 
 

pgsql-general by date:

Previous
From: "Simon Crute"
Date:
Subject: WAL and crash ressialiance
Next
From: "Lyle Lee"
Date:
Subject: NULL indicator variable