Hi
As the Perl hackers say, "tmtowtdt" (there's more than one way to do this) -
you are free to do format your dates wherever you like. If you're that way
inclined you could even do the formatting on the client side in JavaScript ;-)
IIRC correctly PHP offers a lot of inbuilt date formatting wotsits.
In SQL (at least MySQL, database developers also believe tmtowtdt ;-) you can
use the DATE_FORMAT function, see:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
HTH
Ian Barwick
[EMAIL PROTECTED]
On Monday 20 August 2001 18:02, pc wrote:
> Hi people
>
> I am using mySQL and PHP for my web page database management thingy. I've
> managed to get my date field from my Table into my page ($myDate). I was
> wondering, how would I format the date from YYYY-MM-DD format to something
> a bit nicer like DD/MM/YY ?
>
> Is this meant to be a SQL side thing or a server side language formatting
> thingy?
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query tables in a MySQL database is more fun than eating spam"
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php