Peter has made changes in that area specifically geared to dropping
the time component of a date. (I'm assuming you use 310 or 311)
Have a look at the history of changes for more details
Rich Coad wrote:
> I am having trouble with getting dates with greater granularity than days out
> of the InstantDB database.
> The dates are added to the database as a java.util.Date object. When I llok at
> them as they are entered the date is something like Mon Dec 06 10:25:00 PST 1999
> When I retrieve dates from the database they always appear as Dec 06 1999 and
> the time appears as 4:00 p.m.
> It appears as though the time is being discarded in the database and, when I
> retrieve it, a default of 00:00:00 GMT is being appended which then becomes 4
> p.m PST
> I have tried using a dateFormat setting in the properties file and also a call
> to SET DATE FORMAT prior to creating the table. Neither had any effect.
> I also tried wrapping the column name in the select with a call to the TO_DATE
> function. This resulted in a SQLException being thrown.
> Does anyone have experience with getting times down to the granularity of a
> second from InstantDB?
> Rich Coad
> Tech Team
> (415) 430-2369
> Te audire no possum. Musa sapientum fixa est in aure.
> To unsubscribe from this list, please an send
> email to 'firstname.lastname@example.org' with the text
> 'unsubscribe instantdb' in the message body.
Frans van Duinen
Master Programmer Group Inc.
To unsubscribe from this list, please an send
email to 'email@example.com' with the text
'unsubscribe instantdb' in the message body.