Re: SQL server to DB2 SQL

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

Look up DAYOFWEEK or DAYOFWEEK_ISO at
https://www.ibm.com/docs/en/i/7.5?topic=functions-scalar


*-- Find following monday (iso says Monday is 1)*values *dayofweek_iso*(
*date*('2024-10-30'));
*-- 4*values *date*('2024-10-30') + *1* *days*;
*-- 2024-10-31*create table rob.testdate (mydate *date*);
*insert* into rob.testdate values(*date*('2024-10-27'));
*insert* into rob.testdate values(*date*('2024-10-28'));
*insert* into rob.testdate values(*date*('2024-10-29'));
*insert* into rob.testdate values(*date*('2024-10-30'));
*insert* into rob.testdate values(*date*('2024-10-31'));
*insert* into rob.testdate values(*date*('2024-11-01'));
*insert* into rob.testdate values(*date*('2024-11-02'));
*insert* into rob.testdate values(*date*('2024-11-03'));
*insert* into rob.testdate values(*date*('2024-11-04'));
*insert* into rob.testdate values(*date*('2024-11-05'));
select mydate,
*dayofweek_iso*(mydate),
case when *dayofweek_iso*(mydate) = *1* then mydate
else mydate + (*8* - *dayofweek_iso*(mydate)) *days*
end as NextMonday
from rob.testdate
order by mydate asc;

On Sun, Oct 27, 2024 at 11:20 AM Vinay Gavankar <vinaygav@xxxxxxxxx> wrote:

> Hi All,
>
> I have been asked to convert some SQL server SQLs to DB2 SQLs. I am not
> sure what the following SQL is doing and how to convert it. I THINK it is
> getting the date for the Monday of this week. Even if it is true, I don't
> know how to do it in DB2 SQL.
>
> UPDATE DIVTOPRCSS SET EAS_START_DT = CONVERT(VARCHAR (10),DATEADD(DAY,
> DATEDIFF(DAY, 6, GETDATE())/7* 7, 0), 126) WHERE ISSUEID IN ('109452',
> '1099999', '1100000')
>
>
> Any help will be greatly appreciated
>
>
> TIA
>
> Vinay
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.