[thelist] MySQL date format

Chris Dorer cdorer at gmail.com
Mon Nov 28 08:15:01 CST 2005


<snip>
I've a DATE column in MySQL with a row, say "2005-12-1". I want to return
the
following string:

Thursday, 1 - 2 December 2005
</snip>

date( '<your string here>', strtotime( $a_res['mysql_date'] ) );

http://www.php.net/manual/en/function.strtotime.php
http://www.php.net/manual/en/function.date.php

On 11/25/05, Symeon Charalabides <symeon at systasis.com> wrote:
>
> Hi all,
>
> I've a DATE column in MySQL with a row, say "2005-12-1". I want to return
> the
> following string:
>
> Thursday, 1 - 2 December 2005
>
> Is that possible with MySQL functions, or do I have to get PHP to do that?
>
> TIA,
>
> Symeon Charalabides (cosmopolite trainee)
> -------------------------------------------------
> http://www.systasis.com
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>



More information about the thelist mailing list