Re: Need to use weird Date/time to purge records

Instead of iDate you can also use the Db2 scalar function Timestamp_Format.
Timestamp_Format will convert a character string in almost any date format
into a timestamp.

Example:
Timestamp_Format(Digits(YourColumn), 'HH24MISSMMDDYYYY')

If you only need the date, just put a Date() function around:
Date(Timestamp_Format(Digits(YourColumn), 'HH24MISSMMDDYYYY'))

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
„Train people well enough so they can leave, treat them well enough so they
don't want to.“ (Richard Branson)


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Art
Tostaine, Jr.
Sent: Montag, 5. August 2019 19:38
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Need to use weird Date/time to purge records

Thank you for doing this Rob. I'm having trouble getting Idate to work.
SQL tells me token iDate not valid. I'm reading the docs.

On Mon, Aug 5, 2019 at 12:42 PM Rob Berendt <rob@xxxxxxxxx> wrote:

Yes = Know that given enough time and money you can do most anything.

But for the details
values idate(cast(12300108052019 - truncate(12300108052019 /
100000000, 0)
* 100000000 as decimal(8, 0)), '*MDCCYY');
http://www.think400.dk/downloads.htm

Rob Berendt

--
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

--
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