Re: selecting datasets which are updatet within the last x weeks! how?
Originally posted by RKrick
if you don't need the actual week, you can just use 7 days.
For example, for 2 weeks you'll use:
select * from data WHERE date >= current_Timestamp - (2 * 7) days;
If you really need the correct week, I would write a UDF using a combination of DAYOFWEEK(), WEEK() and so on.
I am working with db2V7.2 fixpack 6 AIX 5.2
could you please tell me (detail) how can create UDF? I know the coding of creating UDF but I have problem with how can compile it and how can create the modul in ..../sllib/function.
Thank you in advance for your help.