Re: Problem with date field

2004-11-05 Thread Steve Grosz
t; example, db description, etc.) would permit > some humble humans to take a guess ... > > - Original Message - > From: "Steve Grosz" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, November 05, 2004 8:13 AM > Subject: Problem with

Re: Problem with date field

2004-11-05 Thread Steve Grosz
CREATE TABLE `events` ( `eventID` tinyint(4) NOT NULL auto_increment, `eventDate` date NOT NULL default '-00-00', `eventTitle` tinytext NOT NULL, `eventDesc` mediumtext NOT NULL, PRIMARY KEY (`eventID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | "Gleb Paharenko" <[EMAIL PROTECTED]> wr

Re: Problem with date field

2004-11-05 Thread Gleb Paharenko
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" <[EMAIL PROTECTED]> wrote: > Why am I having a problem getting a date field to hold date? I will store > 2

Re: Problem with date field

2004-11-05 Thread Markus Grossrieder
IL PROTECTED]> Sent: Friday, November 05, 2004 8:13 AM Subject: Problem with date field > 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 > -00-00 > > What's going on he

Problem with date field

2004-11-04 Thread Steve Grosz
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 -00-00 What's going on here? Thanks Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://