Query based on date/time field

I am new to SQL and was wondering how I would go
about selecting records from my database based on 
the age of a date/time stamp.

For example if I wanted to select records older than
12 hours or 1 day.

Any help would be appreciated.

Thanks,

Will McCracken