Re: convert yyyy/mm/dd to mm/dd/yyyy, how?
| From: | Rasmus Lerdorf | Date: | Sun, 13 Jan 2002 19:52:03 +0000 |
| Subject: | Re: convert yyyy/mm/dd to mm/dd/yyyy, how? | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-15723@lists.php.net to get a copy of this message | ||
MySQL has plenty of functions to return dates to you in any format you
specify. Please read
http://mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions
and pay special attention to the DATE_FORMAT() function.
-Rasmus
On Sun, 13 Jan 2002, Sander Peters wrote:
> Hello everybody,
>
> convert yyyy/mm/dd to mm/dd/yyyy, how?
>
> MYSQL does everything in yyyy/mm/dd.
> I live in the Netherlands and we are use to the format dd/mm/yyyy.
>
> What's the best way to display it as mm/dd/yyyy in a table on a query?
>
> My first idea whas to split the date up in vars in php and then print
> the vars in the way I like it
> Is this a bad idea? Or are there better sollutions?
>
> Thanx in advance for answering!
>
>
>
> --
> Met vriendelijke groet / With Greetings,
>
> Sander Peters
>
> site: http://www.visionnet.nl/
> email: mailto:s.peters@visionnet.nl
> webmail: mailto:sanderpeters@yahoo.com
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>