Re: Problem with date field

2004-11-05 Thread Steve Grosz
This is on a Win2003 server system, and MySql server 4.1 ""Markus Grossrieder"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > What's going on here? > God knows ! > Maybe providing some information (OS, version, host app(if any), code > example, db description, etc.) would permit

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
> What's going on here? God knows ! Maybe providing some information (OS, version, host app(if any), code 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, N