Article View: borland.public.interbase.sql
Article #11266Re: Converting DATE. TIME, and TIMESTAMP values for SQL
From: Wayne Niddery [TeamB]
Date: Mon, 02 Dec 2002 00:12
Date: Mon, 02 Dec 2002 00:12
24 lines
1988 bytes
1988 bytes
"Edward Diener" <eddielee@tropicsoft.com> wrote in message news:3dea6388$1@newsgroups.borland.com... > How does one convert: > > 1) A 32-bit integer date value to an acceptable SQL value for a DATE column, > or does a 32-bit numeric value suffice ? > 2) A 32-bit integer time value to an acceptable SQL value for a TIME column, > or does a 32-bit numeric value suffice ? > 3) A 64-bit large integer value to an acceptable SQL value for a TIMESTAMP > column, or does the 64 bit numeric value suffice ? It is impossible to answer this without knowing what the base and format of these 32 / 64 bit values are. Is the 32 bit date a number of days? If so what date does a value of 0 equal? Is the Time value a number of seconds, milliseconds, ...? -- Wayne Niddery (Logic Fundamentals, Inc.) RADBooks: http://www.logicfundamentals.com/RADBooks/delphibooks.html It used to be that other people's achievements were considered an inspiration, not a grievance.
Technical Details
Message-ID:
<3deaa602$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-09!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.uni-x.net!newsgroups.borland.com!not-for-mailReferences:
<3dea6388$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 114a0e,c9629bca0d33469f X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-12-01 16:15:51 PST From: "Wayne Niddery [TeamB]" <wniddery@chaff.aci.on.ca> Newsgroups: borland.public.interbase.sql References: <3dea6388$1@newsgroups.borland.com> Subject: Re: Converting DATE. TIME, and TIMESTAMP values for SQL Date: Sun, 1 Dec 2002 19:12:42 -0500 Lines: 26 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 209.50.82.158 Message-ID: <3deaa602$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1038788098 209.50.82.158 (1 Dec 2002 16:14:58 -0800) X-Authenticated-User: wniddery Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-09!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!news.uni-x.net!newsgroups.borland.com!not-for-mail