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