"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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
