Author Topic: Excel & arsdate  (Read 7035 times)

zancanaro

  • Guest
Excel & arsdate
« on: October 06, 2010, 08:02:16 AM »
Hi all,

Does anyone own the true valor to convert a xxx.arssag  DB_EXP_DATE arsdate to an Excel date formatted ( 3/14/2001) column ?

Thank's a lot.

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Excel & arsdate
« Reply #1 on: October 06, 2010, 11:15:47 AM »
Of course, IBM's official answer to this question is that querying arsdate is the ONLY true method of calculating the 'arsdate' value, which is a good answer when it's feasible.

The basic function is number of seconds since midnight January 1st, 1970, divided by 86400 (ie, the number of seconds in a day). 
You must perform your own time-zone calculations, and there is no accommodation for leap-seconds as far as I know.

Good luck -- and please share your solution!

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

zancanaro

  • Guest
Re: Excel & arsdate
« Reply #2 on: October 11, 2010, 03:21:57 AM »
Hi Justin ,

The true Excel's function is :
=(A1)+25568
Where A1 is the arsdate's value.  Of course, the Excel calculated cellul in format date......
Best regards, Stephane.

zancanaro

  • Guest
Re: Excel & arsdate
« Reply #3 on: October 16, 2013, 01:34:47 AM »
And for times in seconds, the Excel value is :  =(A1  /  86400)  +  25569   //////  Without GMT range .