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 #26716 is a reply to message #26584]

Fri, 14 September 2001 01:58

R.Bauer
Messages: 1424
Registered: November 1998

Senior Member

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)

http://www.fz-juelich.de/icg/icg1/idl_icglib/idl_source/idl_ html/dbase/download/xls2js.tar.gz

regards

Reimar

--
Reimar Bauer

Institut fuer Stratosphaerische Chemie (ICG-1)
Forschungszentrum Juelich
email: R.Bauer@fz-juelich.de
http://www.fz-juelich.de/icg/icg1/
============================================================ ======
a IDL library at ForschungsZentrum Juelich
http://www.fz-juelich.de/icg/icg1/idl_icglib/idl_lib_intro.h tml

http://www.fz-juelich.de/zb/text/publikation/juel3786.html
============================================================ ======

read something about linux / windows
http://www.suse.de/de/news/hotnews/MS.html

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: Sat Nov 29 14:57:44 PST 2025

Total time taken to generate the page: 0.64574 seconds