I forgot that mysql reverses the month and day so I was trying to input yesterdays date (02-28-2002) so it gave me hte default zero value since 28 isn't a valid month number! oops thanks guys.
Thanks! -------------------------------------------- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Alex Behrens" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, March 01, 2002 6:16 PM Subject: Re: using a datetime def in a column... > At 18:07 -0600 3/1/02, Alex Behrens wrote: > >Hi All, > > > >I can't figure this out for the life of me, but since I'm rather new I know > >its a simple problem. I created a table an one of the rows has a 'datetime' > >for the defintions and everytime I instert data into the table it just comes > >up as, "00-00-0000 00:00:00. > > That's pretty strange. MySQL always stores and reports dates by default > in year-month-day order. I'd expect that if you store a date not in that > format, that it would convert it to zero but display it as > "0000-00-00 00:00:00". > > > what is the proper way to insert data into a > >row like this so it will show up with the date that I want it to show up as? > >what is the proper input for MYSQL to use this type of column? > > > >Thanks! > >-------------------------------------------- > >-Alex "Big Al" Behrens > >E-mail: [EMAIL PROTECTED] > >Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) > >Phone: 651-482-8779 > >Cell: 651-329-4187 > >Fax: 651-482-1391 > >ICQ: 3969599 > >Owner of the 3D-Unlimited Network: > >http://www.3d-unlimited.com > >Send News: > >[EMAIL PROTECTED] > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
