aim25 Posted July 10, 2007 Share Posted July 10, 2007 What is the best way to make a field for a date? Quote Link to comment Share on other sites More sharing options...
AdRock Posted July 10, 2007 Share Posted July 10, 2007 Are you using phpmyadmin? Quote Link to comment Share on other sites More sharing options...
per1os Posted July 10, 2007 Share Posted July 10, 2007 I generally use INT(11) and store the date as a UNIX Timestamp. Quote Link to comment Share on other sites More sharing options...
AdRock Posted July 10, 2007 Share Posted July 10, 2007 Or you can use the date field or timestamp field.....i generally use the date field Quote Link to comment Share on other sites More sharing options...
cooldude832 Posted July 10, 2007 Share Posted July 10, 2007 Taking a UNIX time stamp (in seconds) is always best because it stores the most data in the simplest form (not smallest bitwise always) but it will allow you to generate times, dates, hours, minutes, seconds for that given node from 1 number Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.