List:General Discussion« Previous MessageNext Message »
From:(Hal Date:February 6 2012 1:56pm
Subject:Re: how to changing default '-' character in Datetime in MySQL?
View as plain text  
>>>> 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 it to function "date_format":

mysql> select date_format(now(),@@date_format), @@date_format;
+----------------------------------+---------------+
| date_format(now(),@@date_format) | @@date_format |
+----------------------------------+---------------+
| 2012/2/6                         | %Y/%c/%e      |
+----------------------------------+---------------+
1 row in set (0.00 sec)

I have so set it in my configuration file, but have made no use of it other than this
test. 

Thread
how to changing default '-' character in Datetime in MySQL?Rajeev Prasad5 Feb
  • Re: how to changing default '-' character in Datetime in MySQL?hsv5 Feb
    • Re: how to changing default '-' character in Datetime in MySQL?Michael Dykman6 Feb
      • Re: how to changing default '-' character in Datetime in MySQL?Rajeev Prasad6 Feb
        • Re: how to changing default '-' character in Datetime in MySQL?Michael Dykman6 Feb
          • Re: how to changing default '-' character in Datetime in MySQL?Peter Brawley6 Feb
            • Re: how to changing default '-' character in Datetime in MySQL?hsv6 Feb