Storing Dates

[owner]

Hello,

 

I am working on a calendar application.  I was wondering what the best wayto store dates for it would be.  Is there even a way to have mySQL select a date in the form of the unix timestamp where the month = x or the day = x?  I have always just stored them using a unix timestamp with the time() function from php.

 

Any suggestions would be greatly appreciated.

Thanks!

owner

[PravinS]

You can use DATETIME data type.

[straylight]

You are better off with MySQL's DATETIME format, because MySQL's date functions don't work on unix timestamps.

[PravinS]

Run below given query in MySQL

SELECT UNIX_TIMESTAMP(CURDATE());