FW: [PHP-WIN] transforming date format
| From: | Gregory_Griffiths at cargill dot com | Date: | Mon, 18 Dec 2000 16:53:12 +0000 |
| Subject: | FW: [PHP-WIN] transforming date format | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-4526@lists.php.net to get a copy of this message | ||
pull it out in your SQL
to_char('mydate','dd/mm/yyyy')
or you could use some substring routines to split it then put it back
together.
> > -----Original Message-----
> > From: afan@sprout.net [mailto:afan@sprout.net]
> > Sent: 18 December 2000 19:48
> > To: php-windows@lists.php.net
> > Subject: FW: [PHP-WIN] transforming date format
> >
> >
> > Hi to all,
> >
> > Date format in MySQL (date format) is (e.g.) 2000/12/03, but
> > I have to show it as 12/03/2000. How change the format?
> >
> > Afan
> >
>