🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: bionet.software.acedb
Article #2824

Re: dateType

#2824
From: John L. McCarthy
Date: Fri, 01 Apr 1994 00:10
39 lines
2519 bytes
In article <2ne209$er0@mserv1.dl.ac.uk>, mieg@kaa.crbm.cnrs-mop.fr
(Danielle et Jean Thierry-Mieg) wrote:

> 
> I hope it is useful
> To insure better compatibility with OPM and to the request of Dertlef
> i introduced a new basic numeric type in acedb
> _DateType, to be used like _Int and _Float in models
> the whole code nows a bout it.
> 
> It is internally a time_t and arithmetics can be
> preformed on it in particular the query can find the max min average
> off a set of dates, I am not sure if average works well by the way on 
> dates.
> The input format is the "%c: unix format described in man ctime
> sois a string of char but it is internally converted to a time_t number
> 
> This is part of the soon to be released ace.3-1

I think this will be very useful.

As I read man ctime, it says that %c is date and time as %x %X, where 
%x  is date, using locale's date format; and
%X  is time, using locale's time format

e.g, "Thu, 31 Mar 94 02:05:57 PST"

If the format's are locale-dependent, could this cause problems if we
are passing data among different locations in .ace files, and one location
uses different date and time formats from another?  If so, perhaps the
default should be a locale-independent representation.
-- 
+=====================================================================+
|  John L. McCarthy.               . | Internet:..JLMcCarthy@lbl.gov  |
|  Computer Science R&D  MS 50B-3238 | Bitnet: ...JLMCCARTHY@LBL      |
|  Lawrence Berkeley Laboratory     .| telephone: (510) 486-5307      |
|  1 Cyclotron Road                . |                                |
|  BERKELEY, CA 94720, U.S.A.      . | FAX:       (510) 486-4004      |
+=====================================================================+
Technical Details
Message-ID: <jlmccarthy-310394161549@slavsing.lbl.gov>
Path: arc1-ca.pugleaf.net!bga.com!news.sprintlink.net!uunet!news.iij.ad.jp!wnoc-tyo-news!aist-nara!wnoc-kyo-news!kuis-news!s.u-tokyo!biosci!agate!dog.ee.lbl.gov!overload.lbl.gov!slavsing.lbl.gov!user
References: <2ne209$er0@mserv1.dl.ac.uk>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6d40,5fa12b8d3bdb9127
X-Google-Attributes: gidf6d40,public
X-Google-ArrivalTime: 1994-03-31 16:10:54 PST
Path: arc1-ca.pugleaf.net!bga.com!news.sprintlink.net!uunet!news.iij.ad.jp!wnoc-tyo-news!aist-nara!wnoc-kyo-news!kuis-news!s.u-tokyo!biosci!agate!dog.ee.lbl.gov!overload.lbl.gov!slavsing.lbl.gov!user
From: jlmccarthy@lbl.gov (John L. McCarthy)
Newsgroups: bionet.software.acedb
Subject: Re: dateType
Followup-To: bionet.software.acedb
Date: 1 Apr 1994 00:10:54 GMT
Organization: Lawrence Berkeley Laboratory
Lines: 39
Distribution: bionet
Message-ID: <jlmccarthy-310394161549@slavsing.lbl.gov>
References: <2ne209$er0@mserv1.dl.ac.uk>
NNTP-Posting-Host: slavsing.lbl.gov