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

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.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.