mysql datatype date problem

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysql datatype date problem

Postby vineet » 14. October 2008 04:39

hi all

just joined the forum.

i would like to ask that i have set the "datatype" of my date column to "date" in phpmyadmin table i created.

It fetches date from a php form. But when i enter any date say example 1982/10/10 then everytime it displays as 0000-00-00.

vineet
vineet
 
Posts: 1
Joined: 14. October 2008 04:30
Location: India

Postby Wiedmann » 14. October 2008 06:56

But when i enter any date say example 1982/10/10 then everytime it displays as 0000-00-00.

Read the MySQL manual about correct values:
http://dev.mysql.com/doc/refman/5.0/en/datetime.html
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 29 guests