Postgres Pro
Downloads
Home   >   mailing lists

Retrieve Future Timestamp Values - Mailing list pgsql-general

From Adarsh Sharma
Subject Retrieve Future Timestamp Values
Date
Msg-id 4E8EA6B2.2020605@orkash.com
Whole thread Raw
Responses Re: Retrieve Future Timestamp Values  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view 
Dear all ,

I have these timestamp values in one table  in a database.
I need to fetch those rows are greater than the current time, fore.g
today is Friday and i need rows of sunday, monday and so on .

column A                                         Column B
"2011-10-07 09:32:51+05:30";"2011-10-07 11:30:51+05:30"
"2011-10-08 05:32:51+05:30";"2011-10-08 11:50:51+05:30"
"2011-10-08 05:32:51+05:30";"2011-10-08 11:50:51+05:30"
"2011-10-08 15:32:51+05:30";"2011-10-08 18:50:51+05:30"
"2011-10-11 08:32:51+05:30";"2011-10-08 10:50:51+05:30"
"2011-10-11 12:32:51+05:30";"2011-10-11 04:50:51+05:30"
"2011-10-09 12:32:51+05:30";"2011-10-11 13:50:51+05:30"
"2011-10-13 12:32:51+05:30";"2011-10-13 13:50:51+05:30"
"2011-10-15 12:32:51+05:30";"2011-10-15 13:50:51+05:30"
"2011-10-25 12:32:51+05:30";"2011-10-26 13:50:51+05:30"

I want that rows whose value is in future data and time.

Please let me know how to query on comparing timestamp values to
retrieve rows of future date


Thanks

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres 9.01, Amazon EC2/EBS, XFS, JDBC and lost connections
Next
From: tushar nehete
Date:
Subject: Re: How to create database link and synonym in postgresql 9.0