Re: "Number of seconds since January 1, 1970 00:00:00 GMT" for OAuth

Hi,

I did not follow the whole thread, but wouldn't the following SQL Statement
return what you want?

Select Timestampdiff(2, Cast(Current_timestamp -

(Timestamp('19700101000000') - current_timezone)
as VarChar(22)))
from sysibm/sysdummy1

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

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Dennis
Gesendet: Tuesday, 22. November 2011 20:55
An: Midrange Systems Technical Discussion
Betreff: Re: "Number of seconds since January 1, 1970 00:00:00 GMT" for
OAuth

Time zone in both cases for that procedure should be handled automatically.
But please test. :) Glad you like. :)
++
Dennis
++
"No man has a good enough memory to make a successful liar."
-- Abraham Lincoln




Sent from my Galaxy tablet phone. Please excuse my brevity.
For any grammatic/spelling errors, there is no excuse.
++


"James Lampert" <jamesl@xxxxxxxxxxxxxxxxx> wrote:

Dennis Lovelady wrote:

I have created a sample RPG module (and a bare-bones program for

testing

purposes) that I believe will return UTC seconds since epoch. If you

find

that it returns local-time epoch, let me know and I will send the
correction. Code is at: http://code.midrange.com/2040a00004.html

That is SLICK! I thought I'd come up with a simple solution (SUBDUR),
but this is even better (and doesn't require the time zone to be either

hardcoded or explicitly retrieved).

Thanks. About the only thing mine has to recommend it is that it works
in the default activation group, which isn't really a factor, since
yours will also work with ACTGRP(*CALLER), if necessary.

The only potential issue I can see is with Daylight Saving Time.

--
JHHL
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.