"Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
Torsten Roehr wrote:
"Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
Torsten Roehr wrote:
"Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
Environment: PHP 4.3.6 Access DB W2K IIS 5
I'm trying to store a date in a date/time field using the short date format ( m/d/yyyy ). For some reason it won't let me post an empty value to that field in the DB. I've tried using empty quotes ( "" )
or
NULL and I always get a datatype mismatch sql error. So then I just tried submitting a date that will never be used ( e.g. 1/1/1111 ).
That
works, but then when I try to read the date out of the field in the DB and format it using the date() function in PHP it doesn't display anything (which is fine with me). I read up on the date function on
the
PHP website and valid dates are limited from 01-01-1970 to 19-01-2038
on
windows machines. So that explains why the function returns nothing.
So, I guess my question is this: Is what I'm doing technically ok (using a date that's not in the valid range)? Or does anyone know of
an
empty date value that I can submit to the DB?
Thanks!
NULL should work if you have allowed it for the column when creating
the
table. Can you post your table structure?
Regards, Torsten
Well, I would, but I can't seem to figure out how to export just the structure out of access. Wouldn't NULL be allowed by default?
This command should show you the table structure: SHOW CREATE TABLE tablename
Please post the output.
regards, Torsten
Sorry Torsten, but you'll have to forgive my lack of understanding. Where should I put that command in?
Thanks for you patience.
In the mysql command line, if possible or if you're using phpMyAdmin. Should also work with mysql_query() in a php script and echoing out the result. Do you know how to do this?
Regards, Torsten
I'm using Microsoft Access for my database not MySQL. Does that change what I need to do?
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
