realbasic-nug
[Top] [All Lists]

Re: REALSQL Date fields

To: REALbasic NUG <realbasic-nug@lists.realsoftware.com>
Subject: Re: REALSQL Date fields
From: Frank Bitterlich <bitterlich2@gsco.de>
Date: Wed, 29 Apr 2009 10:58:05 +0200
Authentication-results: mx.google.com; spf=neutral (google.com: 74.124.194.228 is neither permitted nor denied by best guess record for domain of realbasic-nug-bounces@lists.realsoftware.com) smtp.mail=realbasic-nug-bounces@lists.realsoftware.com
Delivered-to: listarchive@realsoftware.com
In-reply-to: <5ED05289-8FCC-4805-AE09-41D88E3322A9@ontargetreports.com>
References: <C06B41C7-9E84-4E0D-B845-3BC78DC525A6@gsco.de> <p06240801c60e6ba4c7e2@[10.0.1.4]> <D4862F70-15E7-4330-80F7-1D611A060973@gsco.de> <5ED05289-8FCC-4805-AE09-41D88E3322A9@ontargetreports.com>
Reply-to: REALbasic NUG <realbasic-nug@lists.realsoftware.com>
Sender: realbasic-nug-bounces@lists.realsoftware.com
Hard to say... A binary value (6 bytes) of some sort, 07 D9 00 04 00 11 in hex... unreadable when you assign it to a string or variant.

That might be a .Totalseconds value (or even Unix timestamp?), but I'm too lazy to make a trial-and-error decryption attempt...

Cheers,
   Frank+++


Am 22.04.2009 um 17:26 schrieb Aaron Bratcher:

What does the nativeValue show?
--
Aaron Bratcher

On Apr 20, 2009, at 11:11 AM, Frank Bitterlich wrote:

Peter,

that might be a possible reason. However it is strange that the .StingValue representation of such a "DATE" field does _not_ contain a time component. After all, that's what the TIMESTAMP type is for, at least that's what I thought :)



--

Günter Schmidt GmbH
Frank Bitterlich             eMail: bitterlich@gsco.de
Ben-Gurion-Ring 21           WWW:   http://www.gsco.de/
D-60437 Frankfurt            Tel.:  069 / 156809-29
GERMANY                      Fax:   069 / 156809-28
Geschäftsführer: Jürgen Hartwich
AG Frankfurt am Main, HRB 76504 - USt.-ID: DE235219624






_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>


<Prev in Thread] Current Thread [Next in Thread>