> Hi,
> Can someone tell me how do stote date field in MySQL DB ?
This is the dump from my phpMyAdmin: use this SQL from the command
line and adapt it for your own needs:
# Table structure for table 'item'
#
CREATE TABLE item (
id smallint(4) DEFAULT '0' NOT NULL auto_increment,
name varc
Hi,
it depends on the the MySQL date type you are using.
Here are the formats for the different types.
DATE - '-MM-DD'
DATETIME - '-MM-DD HH:MM:SS'
TIMESTAMP(14) - MMDDHHMMSS
TIMESTAMP(12) - YYMMDDHHMMSS
TIMESTAMP(8) -MMDD
TIMESTAMP(6) -YYMMDD
TI