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

Scott

Thanks for pointing this out. I'm sorry it caused you so much problems. 
I'll see that it gets fixed in the next release.

Pete

----- Original Message -----
From: splante@mindspring.com
Date: Friday, December 29, 2000 1:46 am
Subject: InstantDB: Bug: Wrong default dateTimeFormat in 3.25 

> The dateTimeFormat default listed in the documentation is
>  yyyy-mm-dd hh:nn:ss.lll  
> However, the format listed in the sample.prp, and the format
> used if no value is given in the database prp file is:
>  yyyy-mm-dd hh:mm:ss.lll  
> Note that the token for minutes is supposed to be 'nn', not
> 'mm', which is the token for the month.
> This causes the month to appear in place of the minutes 
> whenever the date is retrieved as a String, such as in the
> SQLBuilder utility. 
> 
> I'm ashamed to say how much time was spent here today 
> trying to figure out why the times we thought we were 
> inserting into the database were not showing up correctly
> when we viewed the database in SQLBuilder.
> 
> The workaround is easy: just fix the dateTimeFormat property
> in the database '.prp' file, or explicitly with the 
> 'SET DATETIME FORMAT' command.  Of course, it should still
> go on the list of things to fix in the next release :-)
> 
> Scott Plante
> 
> see 
> 
http://instantdb.enhydra.org/software/documentation/3.25/types.html#Date
-Type
> -------------------------------------------------------------------
> ----------
> To unsubscribe from this mailing list, send email to 
> majordomo@enhydra.orgwith the text "unsubscribe instantdb" in the 
> body of the email.
> If you have other questions regarding this mailing list, send 
> email to
> the list admin at owner-instantdb@enhydra.org.
> 

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.