List:General Discussion« Previous MessageNext Message »
From:Steve Grosz Date:November 5 2004 4:07pm
Subject:Re: Problem with date field
View as plain text  
CREATE TABLE `events` (
  `eventID` tinyint(4) NOT NULL auto_increment,
  `eventDate` date NOT NULL default '0000-00-00',
  `eventTitle` tinytext NOT NULL,
  `eventDesc` mediumtext NOT NULL,
  PRIMARY KEY  (`eventID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |

"Gleb Paharenko" <gleb.paharenko@stripped> wrote in message
news:pj2s52xjmd.ln2@ style="color:#666">stripped...
> Hi.
> If you send us output of "show create table 'table_with_date_field'",
> and queries, which you use to insert and retrieve date,
> may be we will be able to  help you.
>
>
> "Steve Grosz" <boise_bound@stripped> wrote:
> > Why am I having a problem getting a date field to hold  date?  I will
store
> > 2004-10-15, save the record.  Reopen the record, and there is just
> > 0000-00-00
> >
> > What's going on here?
> >
> > Thanks
> > Steve
> >
> >
> >
>
>
> -- 
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
>  / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
>        <___/   www.mysql.com
>
>
>


Thread
Problem with date fieldSteve Grosz5 Nov
  • Re: Problem with date fieldMarkus Grossrieder5 Nov
  • Re: Problem with date fieldGleb Paharenko5 Nov
  • Re: Problem with date fieldSteve Grosz5 Nov
  • Re: Problem with date fieldSteve Grosz5 Nov