I just played with this a little and it looks like the value returned is in YYYYMMDD digits. Therefore 102 is 1 month and 2 days. I did current date - '03/24/2024' just to see and it returned 10001.
-----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: 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.
midrange.com
