[thelist] SQL: Inserting Time & Date syntax?
Mike King
mike.king at redroom.co.uk
Mon Nov 27 04:47:10 CST 2000
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Frank,
Why not set the date field in the DB to have a date as default? (and make
sure to make it non mandatory!)
I think you'd need to put now() into the default field.
Cheers
mk
At 05:30 27/11/00 -0500, you wrote:
>I'm having problems figuring out the syntax for inserting time and date into
>Access2k from CF. Here's the scenario: The user enters data into a form, date
>formatted as 11/12/2000 or Nov 12, 2000 it goes in fine. Same with inserting
>8:00am.
>
>If the user doesn't enter time or date, I want to make sure there's a
>default to
>prevent an error, so in my insert statement I have
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>
iQA/AwUBOiI7pPoJZSzUdy33EQL+dQCgk78EVHSXIaTNO0+Tl6q63ZP0b+4AoLaJ
/r/mByzvKz58h1XMOjHRl/3O
=KAwk
-----END PGP SIGNATURE-----
More information about the thelist
mailing list