aim25 Posted July 10, 2007 Share Posted July 10, 2007 What is the best way to make a field for a date? Link to comment https://forums.phpfreaks.com/topic/59322-not-sure-how-to-do-this/ Share on other sites More sharing options...
AdRock Posted July 10, 2007 Share Posted July 10, 2007 Are you using phpmyadmin? Link to comment https://forums.phpfreaks.com/topic/59322-not-sure-how-to-do-this/#findComment-294690 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. Link to comment https://forums.phpfreaks.com/topic/59322-not-sure-how-to-do-this/#findComment-294691 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 Link to comment https://forums.phpfreaks.com/topic/59322-not-sure-how-to-do-this/#findComment-294694 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 Link to comment https://forums.phpfreaks.com/topic/59322-not-sure-how-to-do-this/#findComment-294713 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.