I haven't installed iDate yet. But, since our ERP uses CYMD dates, I do have a UDF that I use *all* the time for conversions.
UDF's are a piece of cake to put together. Simplifies my queries tremendously.
Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power
________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of T. Adair <tadair@xxxxxxxxxxxxxxxx>
Sent: Tuesday, March 26, 2019 11:33 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: SQL string to date conversion
idate is certainly doable, but I was looking for a technique that I
could use on any system, whether it has idate or not. We currently
don't have it, thought I like the idea of putting it under the
microscope to see how it works.
I really like Doug's statement - in this case I was able to go with it.
Rob is correct - this is the way to go when feasible.
I very much appreciate Birgitta's input. We store most of our 'dates'
in MMDDYY format, so there will probably be times that I need to use
this technique.
As I have said before, you people are awesome!
Thanks again.
~TA~
On 3/26/2019 1:19 PM, T. Adair wrote:
Thanks to all who replied. I now have some shiny new tools in my toolbox.
~TA~
--
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@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
