mysql date column type
Posted by: pureessence on: April 11, 2005
i have to say that the decision to make the birthday column for members on the new board type DATE is a very good one. i never knew about all the magic mysql DATE type can do 
but i still love the simplicity of time arithmetic unix timestamp provides.
5 Responses to "mysql date column type"
April 11, 2005 at 6:21 pm
heehee.. I tried to tell you! I’ve use mysql date too much.. I don’t even know how to revert back to unix timestamp.
April 12, 2005 at 8:33 am
actually you can do something like select UNIX_TIMESTAMP(date_column) and it returns the unix timestamp. tho i still don’t see a very convenient way with date type to figure something like how many days it’s from a certain date. in unixstamp, you can just do
($timerightnow - $dateinquestion) / 24 * 3600 = NUM OF DAYS
May 27, 2005 at 10:40 am
What I don’t like about having unix timestamps in the database is that it is impossible to read for the human eye. Which means, that when browsing the database with phpMyAdmin it’s really difficult to actually look at the dates. That’s why I more often than not set the type as DATE. 
December 13, 2007 at 9:11 am
I have started using mysql based dates, times, timestamps instead of doing work with PHP, and my work has became much easier. If you trying to decide if place unix timestamp in the database or mysql native, GO for mysql one, your life will be easier too :biggrin:
Leave a Reply
Search
Social Media
dodozhang21 @ facebook
dodozhang21 @ twitterMy most adorable Pomeranians
- ICHC selection
- You Know It's Love When
- Smile Quotes
- Wordpress Theme: oriental
- jQueryUI dialog as loading screen (replace blockUI)
- Application to Date My Daughter
- jQuery session timeout countdown with jQueryUI dialog
- IE input background image issue
- How to STYLE a table using CSS (JSF examples)
- jQuery plugin - tableRowCheckboxToggle
- Dorababu: Is it possible to have two buttons like Yes and No instead of Ok
- pureessence: There is no code in there. It's just a url you call to keep your session alive. Whatever it is for your application. It's only an example.
- karls: Thank you for this nice example! i already embedded in my app.
April 11, 2005 at 4:25 pm
Wow, thanks for the link! I’ve been working with PHP and built-in dates in mySQL and I kept running into problems
uch: I can’t wait to give this a try!