Sorry, the function is UNIX_TIMESTAMP(date). That will create a unix timestamp from your date column. Use FROM_UNIXTIME() to create a MySQL timestamp from a unix one.
I'd recommend, though, that you just look up DATE_FORMAT() in the MySQL manual and just use that. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #Date_and_time_functions ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -----Original Message----- > From: Paul Sharpe [mailto:[EMAIL PROTECTED] > Sent: Monday, March 24, 2003 7:34 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] mysql timestamps > > I hope you don't mind me bothering you like this but you seem to know what > you're talking about, you replied to my post on php.db in case you are > wondering who the heck I am. > > I tried the "SELECT TO_UNIXTIME(your_column) FROM table" command in mysql, > but i got an error returned > "ERROR 1064: You have an error in your SQL syntax near '(date) FROM news' > at > line 1" > > I've tried putting a space between the TO_UNIXTIME and (date) <--the name > of > my column but still no avail > > If you don't want me bothering you let me know > > Any help would be genuinely appreciated > > thanks > Paul Sharpe > ----- Original Message ----- > From: "John W. Holmes" <[EMAIL PROTECTED]> > To: "'Paul Sharpe'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, March 24, 2003 3:08 AM > Subject: RE: [PHP-DB] mysql timestamps > > > > > how do i change the format of a MySQL timestamp (i.e hh:mm:ss > > DD/MM/YYYY > > > instead of YYYYMMDDhhmmss) retrieved from a mysql database with php? > > > > Use > > > > SELECT TO_UNIXTIME(your_column) FROM table ... > > > > And then use date() in PHP to format the result to your liking. > > > > Or, you can use DATE_FORMAT() in your query to format the result to your > > liking. > > > > ---John W. Holmes... > > > > PHP Architect - A monthly magazine for PHP Professionals. Get your copy > > today. http://www.phparch.com/ > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
