https://www.webmaster-forums.net/crss/node/1014088 en https://www.webmaster-forums.net/serverside-scripting/question-about-mysql-timestamp#comment-1081367 <p>wooohh kuel!<br /> I may have to go back and convert some of those table now <img src="https://www.webmaster-forums.net/misc/smileys/smile.png" title="Smiling" alt="Smiling" class="smiley-content" /></p> Wed, 18 Apr 2001 17:56:05 +0000 Mark Hensler comment 1081367 at https://www.webmaster-forums.net https://www.webmaster-forums.net/serverside-scripting/question-about-mysql-timestamp#comment-1081365 <p>MySQL has a functin unix_timestamp() that will convert it into a unix timestamp. </p> <p>That solved my problem, so now I can use built in sql time seaching functions and get unix timestamps for php's date() formatting function.</p> Wed, 18 Apr 2001 17:46:50 +0000 Randall comment 1081365 at https://www.webmaster-forums.net https://www.webmaster-forums.net/serverside-scripting/question-about-mysql-timestamp#comment-1081360 <p>I played with the mySQL timestamp breifly. Didn't get the results I wanted, so I've used INT(11) ever since.</p> <p>...just did a search at mysql.com and got these:<br /> <a href="http://www.mysql.com/doc/D/a/Date_and_time_functions.html" class="bb-url">http://www.mysql.com/doc/D/a/Date_and_time_functions.html</a><br /> <a href="http://www.mysql.com/doc/D/A/DATETIME.html" class="bb-url">http://www.mysql.com/doc/D/A/DATETIME.html</a></p> Wed, 18 Apr 2001 17:23:43 +0000 Mark Hensler comment 1081360 at https://www.webmaster-forums.net