RE: [PHP-DB] mysql timestamps
| From: | John W. Holmes | Date: | Mon, 24 Mar 2003 13:21:27 +0000 |
| Subject: | RE: [PHP-DB] mysql timestamps | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26596@lists.php.net to get a copy of this message | ||
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:Jesusdiscs@ntlworld.com]
> Sent: Monday, March 24, 2003 7:34 AM
> To: holmes072000@charter.net
> 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" <holmes072000@charter.net>
> To: "'Paul Sharpe'" <Jesusdiscs@ntlworld.com>;
> <php-db@lists.php.net>
> 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
> >
> >
>