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

Error in function js2ymds (JHU/APL/S1R IDL Lib)? [message #26584]

Thu, 13 September 2001 09:44

Olaf Stetzer
Messages: 39
Registered: September 2001

Member

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
---
However I realised that the dates which result from
my computation differ from the ones that I get when
I just change the format setting in Excel!

Some Examples:

msdate msdate (formatted) js2ymds

1 1900 1 1 1900 1 1
366 1900 12 31 1901 1 1
12481 1934 3 3 1934 3 4
36682 2000 6 5 2000 6 6

It seems that in the MS-year 1900 has 1 more day
compared to the one calculated by js2ymds!! I don't
know if the fault is in Microsoft Excel or in the
function js2ymds but maybe in 1900 there was an
extra switching day (german: Schalttag) which is
not calculated in the function?

Greetings,

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: Fri Oct 10 10:54:23 PDT 2025

Total time taken to generate the page: 0.47812 seconds