mysql date input

Question

I have a database table--> date field and the date format is yyyy-mm-dd

if i input in anouther format then field show 0000-00-00

what is the problem and how i can overcome this whereas i have use no form encode method??

Ólafur Waage · Accepted Answer · 2009-07-04 09:38:40Z

1

I would recommend using int(32) for your date field and storing unixtime. That way you can format your date into any type of string you want to display.

UNIX_TIMESTAMP()

It's called and the you can do this in your query.

INSERT INTO `table` (`date`) VALUES (UNIX_TIMESTAMP());

You can parse unixtime in any language, and many (like PHP) have built it parsing of unixtime.

date("Y-m-d", $row["time"]); // YYYY-MM-DD

answered Jul 4, 2009 at 9:38

Ólafur Waage

70.3k22 gold badges147 silver badges199 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Christian Over a year ago

This also makes it easier for date calculations (ie if($date1 < $date2) { print "date1 was before date2!"} );

Alan Haggai Alavi · Accepted Answer · 2009-07-04 09:41:25Z

1

Insert dates in YYYY-MM-DD (ISO format) and when retrieving the date, you may convert it to any format you like using:

DATE_FORMAT()

Reference:

DATE_FORMAT(date,format).

answered Jul 4, 2009 at 9:41

Alan Haggai Alavi

74.7k19 gold badges105 silver badges129 bronze badges

Collectives™ on Stack Overflow

mysql date input

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related