comp.lang.idl-pvwave archive: archive » Error in function js2ymds (JHU/APL/S1R IDL Lib)?

Home » Public Forums » archive » Error in function js2ymds (JHU/APL/S1R IDL Lib)?

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: Error in function js2ymds (JHU/APL/S1R IDL Lib)? [message #26714 is a reply to message #26584]

Fri, 14 September 2001 02:18

Olaf Stetzer
Messages: 39
Registered: September 2001

Member

Reimar Bauer schrieb:
>
> Olaf Stetzer wrote:
>>
>> Hello,
>>
>> as mentioned in my last posting I want to convert
>> Date/Time from Microsoft(Excel)-Format (based on
>> 1.1.1900= day 1) into Julian Seconds and then from JS
>> into the ODBC-SQL-TIMESTAMP-struct.
>>
>> For the last conversion I've written a function
>> which basically runs js2ymds to get the values
>> for y m d and then computes hh mm ss from the
>> resulting seconds.
>>
>> All values are then stored in the aforementioned struct.
>>
>> I now tried to compute the js from MS-Format and then
>> use my function to store this in the sqlstruct:
>> ---
>> function mstime2sqlts, msdate, mstime
>>
>> jsdate=(msdate-1)*86400d0-3155673600d0
>> js=mstime*86400d0+jsdate
>> sqlts=js2sqlts(js)
>> return, sqlts
>>
>> end
>> ---
>
> Dear Olaf,
>
> We are calculating the jstime from Microsoft special time in this way
>
> js_time= mstime*24d*3600+xls2js(msdates)
>

Are you sure that this function is aware of the 29.2.1900-bug in
ms-date? By looking at the code for xls2js I am not sure about this!

Olaf

--
Dr. Olaf Stetzer
Forschungszentrum Karlsruhe
Institut fï¿½r Meterologie und Klimaforschung
Atmosphï¿½rische Aerosole (IMK III) - http://imk-aida.fzk.de
Tel.: +49(0)7247-82-3249 (FAX: -4332)

Report message to a moderator

[Message index]

		Error in function js2ymds (JHU/APL/S1R IDL Lib)? By: Olaf Stetzer on Thu, 13 September 2001 09:44
		Re: Error in function js2ymds (JHU/APL/S1R IDL Lib)? By: R.Bauer on Fri, 14 September 2001 03:14
		Re: Error in function js2ymds (JHU/APL/S1R IDL Lib)? By: Olaf Stetzer on Fri, 14 September 2001 02:39
		Re: Error in function js2ymds (JHU/APL/S1R IDL Lib)? By: Olaf Stetzer on Fri, 14 September 2001 02:18
		Re: Error in function js2ymds (JHU/APL/S1R IDL Lib)? By: Olaf Stetzer on Fri, 14 September 2001 02:10
		Re: Error in function js2ymds (JHU/APL/S1R IDL Lib)? By: R.Bauer on Fri, 14 September 2001 01:58
		Re: Error in function js2ymds (JHU/APL/S1R IDL Lib)? By: R.Bauer on Fri, 14 September 2001 00:34
		Re: Error in function js2ymds (JHU/APL/S1R IDL Lib)? By: Olaf Stetzer on Fri, 14 September 2001 00:06
		Re: Error in function js2ymds (JHU/APL/S1R IDL Lib)? By: Harald Giese on Thu, 13 September 2001 17:09

Previous Topic:	Multi-threaded IDL
Next Topic:	phase unwrapping

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Oct 12 00:40:01 PDT 2025

Total time taken to generate the page: 2.15786 seconds