brady.k — Tue, 02 Dec 2003 21:39:26 +0000

thanks!

Mark Hensler — Mon, 01 Dec 2003 09:50:32 +0000

If needed, you may also read about setlocale() (I've never used it).

Suzanne — Mon, 01 Dec 2003 01:39:08 +0000

A MySQL date setting in a database is in the YYYYMMDD HHMMSS format anyway. i.e. you can't put it into the database in any other format. (You can use YY:MM and such, but the order is always YYYYMMDD HHMMSS). To take input that isn't in the right format, see "STR_TO_DATE(str,format)" in the link below.

http://www.mysql.com/doc/en/Date_and_time_functions.html (scroll down or ctrl-f to "DATE_FORMAT(date,format)" for details on how to format it out of the database.)

The best idea is to provide educational assistance to your users or split the entry into year, month, day. For pulling it out, you can parse it as you wish and display it in any format.

brady.k — Mon, 01 Dec 2003 01:18:28 +0000

ok, but what if i'm pulling the data from a MySQL db?

Suzanne — Sat, 29 Nov 2003 02:36:10 +0000

lol, clearly you've not bumped into dates like 04/07/00 and had them interpreted as April 7th and July 4th, which can lead to an incredible contamination of the data.

nike_guy_man — Sat, 29 Nov 2003 02:20:51 +0000

No, it makes sense...
Put all the #s at the end and all the big words in the beginning

November 28, 2003

See, makes sense

No need to change it, besides... who would listen?

druagord — Fri, 28 Nov 2003 21:01:19 +0000

I must admit US date format really is illogical

Suzanne — Fri, 28 Nov 2003 20:52:22 +0000

I say you break with convention and teach your country-mates the right way to go...

druagord — Fri, 28 Nov 2003 18:42:53 +0000

i guess you mean in php

<?php
$date_array = get_date();
echo $date_array['mon'].\"-\".$date_array['mday'].\"-\".$date_array['year'];
?>

you need a date other then today you can specify a timestamp as a parameter to get_date