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: InstantDB: now newbie question


Myriam

It's probably best to make sure you're using IDB 3.26 and that you use the TIMESTAMP type
for times. 3.26 has much better handling for dates/times and more sensible defaults.

Pete
----- Original Message -----
From: "Myriam Abramson" <abramson@nlm.nih.gov>
To: <instantdb@enhydra.org>
Sent: Wednesday, February 21, 2001 4:50 PM
Subject: InstantDB: now newbie question


>
> Hi!
>
> I don't know exactly how it should work but the way I'm doing it does
> not seem to work:
>
> I did set nowMeansTime to 1 in the .prp file
>
> The table has a DATE slot that I would like to fill with today's
>  date.
>
>  "updatedate     DATE"
>
> I have an insert statement as such:
>
> "INSERT INTO " + name + " VALUES " +
> "(" + id + ",now,\'" + stuff + "\',\'" + stuff1 + "\'," + "\'" +
> stuff2 + "\')"
>
> When I look at what has been inserted, I get a "y" instead of a
> date. How should that exactly work?
>
> Thanks,
> --
>                                           myriam
>
> Go Proverb:
>
> Fill in a semiai from the outside.
> -----------------------------------------------------------------------------
> 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.
>


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