From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-2.9 required=5.0 tests=BAYES_00,MAILING_LIST_MULTI autolearn=unavailable autolearn_force=no version=3.4.4 X-Google-Thread: 103376,a875d9649dde34e3 X-Google-Attributes: gid103376,public X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news1.google.com!news1.google.com!news.glorb.com!news.agarik.com!usenet-fr.net!enst.fr!melchior!cuivre.fr.eu.org!melchior.frmug.org!not-for-mail From: Stephen Leake Newsgroups: comp.lang.ada Subject: GWindows Database time type Date: 29 Sep 2004 20:13:23 -0400 Organization: Cuivre, Argent, Or Message-ID: References: NNTP-Posting-Host: lovelace.ada-france.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: melchior.cuivre.fr.eu.org 1096503215 96256 212.85.156.195 (30 Sep 2004 00:13:35 GMT) X-Complaints-To: usenet@melchior.cuivre.fr.eu.org NNTP-Posting-Date: Thu, 30 Sep 2004 00:13:35 +0000 (UTC) To: comp.lang.ada@ada-france.org Return-Path: In-Reply-To: User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at ada-france.org X-BeenThere: comp.lang.ada@ada-france.org X-Mailman-Version: 2.1.4 Precedence: list List-Id: "Gateway to the comp.lang.ada Usenet newsgroup" List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Xref: g2news1.google.com comp.lang.ada:4419 Date: 2004-09-29T20:13:23-04:00 Fionn mac Cuimhaill writes: > On another front - the proposed bug list. I have an item for it. > This might be described as a restriction rather than a bug; this is in > GWindows.Databases. I was using one of the Field_Value functions to > get a SQL Server datetime value into a variable of type Time (as > defined in Ada.Calendar). The problem is that the range of dates that > can be expressed with a variable of type Time is too narrow, and one > of the GNATCOM routines which converts the date extracted from SQL > Server into a Time choked on a date with a year before 1901. > > GNATCOM and GWindows need a calendar package similar to Ada.Calendar > which is based on a native Windows time representation. Native Windows might be the wrong choice; databases are hosted on many operating systems, and GWindows should be able to provide clients for any of them, possibly thru ODBC. Here's a fragment from the MySQL manual (http://dev.mysql.com/doc/mysql/en/TIME.html): MySQL retrieves and displays TIME values in 'HH:MM:SS' format (or 'HHH:MM:SS' format for large hours values). TIME values may range from '-838:59:59' to '838:59:59'. For that, Time needs to be a string; that will always be the most general format. I couldn't find my SQL reference, so I'm not sure if that's standard SQL or not. Anybody have a URL for a good SQL reference? This gets back to "What are the requirements for GWindows"? Should it meet some industry standard for SQL? or match MySQL, which is a popular Open Source database? Or something else? -- -- Stephe