title: How to compare dates in Netezza?
body: <p>I am a new learner in Netezza. Right now, I wanna write a sql statement to feedback the recent data objects corresponding to a defined recent date. Like return the data objects after 2014-06-10. Or return the objects before a certain date. Like return the data objects before 2014-03-10. How to do that? The attribute in where clause is timestamp. I assume it is a simple process; however, I cannot find it. Thank you in advance, guys!</p>