[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