On 07/10/2011 08:13, Adarsh Sharma wrote: > 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 Easy! - select .... where my_column > current_timestamp; Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
