Vijay Yadav

Vijay Yadav

  • NA
  • 1.4k
  • 651.1k

get the data of last three hours inserted in the table

Mar 31 2011 9:23 AM

Hi,

I want to get the data of last three hours inserted in the table, i wan to know how i will subtract three hours.

 for eg: "select * from table_1 where date_time between CURRENT_TIMESTAMP and ..."

 Any help?



Answers (12)