Re: SQL server to DB2 SQL

'Twas I ... ChatGPT did an imperfect but very helpful job Db2 -> MSSQL.
Try it the other direction and let us know what happens!



________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Bryan Dietz <bdietz400@xxxxxxxxx>
Sent: Sunday, October 27, 2024 3:05 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL server to DB2 SQL

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

i recall reading over on Ryver someone using one of the AI sites to
assist in SQL conversion.

Bryan

Vinay Gavankar wrote on 10/27/2024 10:20 AM:

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

--

-- .
Bryan

--