On 2/5/2012 9:21 PM, Michael Dykman wrote:
You are right. It seems to have fallen into disuse since I used it last.
AFAIK it has never been used.
PB
-
At any rate, the format does not affect storage. I, like most others,
generally specify the format using the date_format function wit
You are right. It seems to have fallen into disuse since I used it last.
At any rate, the format does not affect storage. I, like most others,
generally specify the format using the date_format function within the
queries themselves. It is more stable way to proceed anyhow;
otherwise, your cod
thx Michael,
but the page says:
* date_format
This variable is unused.
*datetime_format
This variable is unused.
- Original Message -
From: Michael Dykman
To: mysql mailing list
Cc:
Sent: Sunday, February 5, 2012 9:24 PM
Subject: Re: how to changing default '-
To clarify, what we are discussing is the "date format". It has
nothing to do with how it is stored. It is stored as binary data
whatever your format is. What the date format does effect is how that
data is formatted upon conversion to a string, assuming the
date_format() method has not been spec
2012/02/04 19:13 -0800, Rajeev Prasad
MySQL datetime field type keeps data as: -MM-DD HH:mm:SS is there a way to
store this data as: /MM/DD HH:mm:SS or going much further (optionally) can
we store as: MM/DD/ HH:mm:SS ? if not then whats the best way to
reformat the cell