RE: [PHP] Re: Formating datevariables...
| From: | John Holmes | Date: | Wed, 24 Jul 2002 01:47:25 +0000 |
| Subject: | RE: [PHP] Re: Formating datevariables... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-109187@lists.php.net to get a copy of this message | ||
> Thanx for the help..
>
> I ended up with this solution ;)
>
> $dag = substr ( $row['endret_dato'], 7, 2 );
> $mnd = substr ( $row['endret_dato'], 4, 2 );
> $aar = substr ( $row['endret_dato'], 0, 4 );
>
> date ("dmY", mktime(0,0,0,$mnd,$dag,$aar) )
Did you even read the replies? Why are you going to do a bunch of string
manipulation, mktime, and date calls in PHP when you can just use
DATE_FORMAT() in your query and get exactly what you want without any
additional work by PHP?
Take a little time and Read Chapter 6 of the MySQL manual. It will save
you a ton of work later on...
---John Holmes...
> -R
>
> "Ragnar" <ragnar@chello.no> wrote in message
> news:20020722234455.41274.qmail@pb1.pair.com...
> > I have a column in a mysql table with a timestamp. The value of this
> column
> > is for instance:
> >
> > 20020722185242
> >
> > How do i change the format on this to "DDMMYYYY" (22072002) in php?
> >
> > Thanx
> >
> > -R
> >
> >
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php