I think the 102 represents 1 month 2 days.
Select days(current date) - days('02/22/2024') to get the number in days
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of eric bothes
Sent: Monday, March 25, 2024 8:53 AM
To: Midrange-L <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] sql date difference gotcha
just an fyi for anyone using the following logic and thinking it will return the number of days difference as i though.
i was expecting the following results
1, 2, 3, but i was incorrect.
assume current date = 03/25/2024
SELECT
current date - '03/24/2024' as days1,
current date - '02/23/2024' as days2,
current date - '02/22/2024' as days3 FROM SYSIBM.SYSDUMMY1
the results are
1, 102, 103, where results returned are yymmdd format.
--
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.
[CAUTION! This email originated outside of the organization. Please do not open attachments or click links from an unknown or suspicious origin.]
midrange.com
