Make your own free website on Tripod.com

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

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


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

Re: Date Columns


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?
> 
> Thanks,
> 
>  --
> Rich Coad
> Tech Team
> iSyndicate.com
> (415) 430-2369
> Te audire no possum. Musa sapientum fixa est in aure.
> To unsubscribe from this list, please an send
> email to 'majordomo@smartcard.co.uk' with the text
> 'unsubscribe instantdb' in the message body.

-- 
Frans van Duinen
     (416) 652-8580
     Master Programmer Group Inc.
     Toronto, Ontario
To unsubscribe from this list, please an send
email to 'majordomo@smartcard.co.uk' with the text
'unsubscribe instantdb' in the message body.

  • References: