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

Reply via email to