2012/02/05 21:56 -0800, Peter Brawley
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.
One use occurred to me, and I was thinking of this, to set date_format in the
configuration file, and pass
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 value
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
thx Michael,
but the page says:
* date_format
This variable is unused.
*datetime_format
This variable is unused.
- Original Message -
From: Michael Dykman mdyk...@gmail.com
To: mysql mailing list mysql@lists.mysql.com
Cc:
Sent: Sunday, February 5, 2012 9:24 PM
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
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