Thanks a lot..
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
it would be better to ask at DB2-L,
but the answer is something like
SELECT ...
FROM CUSTOMER_ORDER
WHERE TS_COLUMN <= CURRENT TIMESTAMP - 2 YEARS;
Specify the columns you want in the result in the select list (replacing
the three dots),
the correct table name and qualifier after FROM
and the
There is certainly a sense in which Lizette Koehler's response to the OP---Ask
your question in the appropriate DB2 forum---is the right one.
On the other hand, the CONVTOD macro converts date-and-time data into the
equivalent STCK[E] value, in this case that of a date-and-time value for tw
> -Original Message-
> From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On
> Behalf Of Ron Thomas
> Sent: Monday, January 18, 2010 7:14 AM
> To: IBM-MAIN@bama.ua.edu
> Subject: Timestamp comparison
>
> Hello.
>
> I have a table Customer_Order,
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
-
5 matches
Mail list logo