sql - Mysql: Get all records which are insert before certain hour -

i need query rows table insert before hours.

let 1 hour. need records table insert before 1 hour.

i have "createdon" column in table.

for example, have table foo, columns follows:

• id
• name
• created_on (with timestamp set default)

there records, follows:

first record - 1 - - 2013-07-19 04:12:00

second record - 2 - b - 2013-07-19 02:00:00

if current time 5:00 pm, query should return second record only. not first record because created in hour.

try sql

select  * tablename datecolumn > (datepart(hh,getdate())-1) 

you can replace 1 value want.