There is a DB2 Newsgroup that this might be better posted to. Go to this link and join (its free) if you have not already.
The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here http://www.idug.org/register Lizette > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of Ron Thomas > Sent: Monday, January 18, 2010 7:14 AM > To: [email protected] > Subject: Timestamp comparison > > Hello. > > I have a table Customer_Order, where one of the coloumns is a order > entry > which is of type time stamp, i need to sql to pick all the records > which are 2 > yrs old , could some one please let me know how we can do this? > > Regards > Ron > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
