Hi,
You could write a PHP script to get all the current
values (I presume that you've put varchar as
datatype), parse them with string functions and
convert it in the way you'd like them to be. All this
is not so difficult to make.
I prefer to store my date/times in the UNIX timestamp
form. I use an int(10) field in mySQL database
(int(10) means an integer with 10 digits, this way I
can store more than 331 years!). This is easy to sort
and to calculate with too. In your development you can
use this timestamp and format it in any way you want
it using the date() function.
You'll find all references in the php.net manual.
Greetz,
Bjorn Van Simaeys
www.bvsenterprises.com
--- Christopher CM Allen <[EMAIL PROTECTED]> wrote:
> Greetings:
>
> I have a field entry in a MYQSL table that stores
> the date as:
> August 02, 2001 :(
>
> Is there anyway to convert this to 08-02-2001
> outside of the table via php?
>
> Better yet is there ayway I can go back into my
> table and change these dates
> into a better format for computation?
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
