Retrieve Future Timestamp Values
| От | Adarsh Sharma |
|---|---|
| Тема | Retrieve Future Timestamp Values |
| Дата | |
| Msg-id | 4E8EA6B2.2020605@orkash.com обсуждение исходный текст |
| Ответы |
Re: Retrieve Future Timestamp Values
|
| Список | pgsql-general |
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 по дате отправления: