What's the best way to put a date into a database? - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

srsdude · 12-22-2009, 07:19 PM

What's the best way to put a date (like 11-10-2009) into a MYSQL database so that later I can get the day, month, and year separately instead of just a text string with the whole thing?
Should I create a table field for each one? Should I make it into a text string like
"11-10-09" and then later "explode()" it into an array? (I'm using PHP)

manzar · 08-04-2010, 03:05 AM

all date calculations are done using the YYYY-MM-DD format (MySQL DATE format).

you to leave the DATE format in the db as it is, so you can do calculations, searches etc. Only re-format the date to your required format when displaying it to the user using the DATE_FORMAT MySQL command:

DATE_FORMAT(your_date, "%d-%e-%Y")

shanthi · 08-11-2010, 03:35 AM

Something useful information to all!!!!

ann1985 · 08-13-2010, 03:06 AM

dexter dvd box set does not disappoint. Based on the novels of Jeff Lindsay, dexter dvd box set is the story of a serial killer who murders other serial killers. While yes he is a sociopath, I find that one of the most fascinating parts of both the novels and the Showtime series is that slowly dexter dvd box set is starting to show that he may even be developing emotions.