Re: how to changing default '-' character in Datetime in MySQL?

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 configuratio

Re: how to changing default '-' character in Datetime in MySQL?

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 '-' character in Datetime in MySQL? To clarify, what we are discussing is

Re: how to changing default '-' character in Datetime in MySQL?

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 '-' character in Datetime in MySQL? > > To clarify, what we are discus

Re: how to changing default '-' character in Datetime in MySQL?

'-' character in Datetime in MySQL? 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

Re: how to changing default '-' character in Datetime in MySQL?

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

Re: how to changing default '-' character in Datetime in MySQL?

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

Re: datetime in mysql

CurlyBraces Technologies ( Pvt ) Ltd wrote: hi , i have created datetime field in the field name "abc". so i want to get the system date and time automatically to the abc field for in each records. how can i do that ?can somebody help me ..plz define the column as timestamp --

Re: datetime in mysql

TED] Sent: Friday, February 27, 2004 7:09 AM Subject: Fw: datetime in mysql - Original Message - From: CurlyBraces Technologies ( Pvt ) Ltd To: mos Sent: Friday, February 27, 2004 11:51 AM Subject: Re: datetime in mysql sorry , as u said , i did it . it doesn't

datetime in mysql

hi ,   i have created datetime field in the field name "abc". so i want to get  the system date and time automatically to the abc field for in each records. how can i do that ?can somebody help me .plz   thanx in advance curlys   -- MySQL General Mailing List For list archiv

Fw: datetime in mysql

  - Original Message - From: CurlyBraces Technologies ( Pvt ) Ltd To: mos Sent: Friday, February 27, 2004 11:51 AM Subject: Re: datetime in mysql sorry , as u said , i did it . it doesn't work for me .This table i want to view in the Web. So that date and time must