Re: transforming date
| From: | David Tod Sigafoos | Date: | Thu, 07 Dec 2000 21:28:58 +0000 |
| Subject: | Re: transforming date | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-4368@lists.php.net to get a copy of this message | ||
Hello afan,
Thursday, December 07, 2000, 3:54:03 PM, you wrote:
a> Hi all,
a> If you query a date from mysql and it returns
a> 2001-01-01
a> how can I format this to be
a> 01/01/2001
a> Thanks
this is a mysql answer to your problem. I will leave the php answer
to your investigation of the manual
the same question was answered this am by kill-9 ..
select date_format(date_field,"%d/%m/%y") from table_name;
check
http://www.mysql.com/documentation/mysql/commented/manual.php?section=Date_a
nd_time_functions
--
DSig
David Tod Sigafoos
mailto:dsig@teleport.com
Using 'The Bat' 1.48 Beta/8
`````
( O O )
_______oOOo__( )__oOOo_______