InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples

CVS Repositories

Who We Are
News, Articles & Events
Getting Involved
Contact Us

Case Studies
On The Edge! -NEW-
Commercial Vendors

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Date Columns

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 '' with the text
'unsubscribe instantdb' in the message body.

  • Follow-Ups: