Re: Date/Time Formatting
| From: | Richard Lynch | Date: | Fri, 19 Jan 2001 18:14:32 +0000 |
| Subject: | Re: Date/Time Formatting | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-35674@lists.php.net to get a copy of this message | ||
> Also I'd like to if possible to be able to enter and display the date in
> Australian / European Time format (DD,MM,YYYY)
> I'm currently entering it on the form using three text fields and then
> rearanging them to the Format in mySQL and indserting it as a string, but
I
> don't know how to 'break' up a mySQL Date value to rearange it.
The breaking up of a MySQL date would be in the MySQL manual at
http://mysql.org
I dunno what it's called... In PostgreSQL it's "date_part" though :-)
I'm afraid there was another question in there somewhere, but I couldn't
really discern it -- What you are doing seems quite reasonable to me.