From: Michael Dykman
Date: May 7 2010 4:05pm
Subject: Re: Changing date result automatically
List-Archive: http://lists.mysql.com/mysql/221528
Message-Id: <j2l814b9a821005070905reaf6b876na56db7062fd4ddf1@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

You build pretty much any format you desire out of those speifiers.  ie:

select date_format(now(),'%m/%c/%Y');

 - md

On Thu, May 6, 2010 at 5:00 PM, Weydson Lima <weyseal@stripped> wrote:
> I was referring to the function:
>
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#funct=
ion_date-format
>
> ---
> Weydson Lima
> weyseal@stripped
>
>
> On Thu, May 6, 2010 at 1:58 PM, Martin Gainty <mgainty@stripped> wrote=
:
>
>> =A0http://lists.mysql.com/commits/60834
>>
>> date_format system variable is currently an unused system variable
>>
>> Martin Gainty
>> ______________________________________________
>> Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentiali=
t=E9
>>
>> Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene
>> Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefug=
te
>> Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachrich=
t
>> dient lediglich dem Austausch von Informationen und entfaltet keine
>> rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von
>> E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
>>
>> Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EA=
tes pas le destinataire pr=E9vu, nous te demandons avec bont=E9 que pour sa=
tisfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9=
e ou la copie de ceci est interdite. Ce message sert =E0 l'information seul=
ement et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant =
donn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation,=
 nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni.
>>
>>
>>
>>
>>
>>
>> > From: weyseal@stripped
>> > Date: Thu, 6 May 2010 11:44:37 -0500
>> > Subject: Changing date result automatically
>> > To: mysql@stripped
>>
>> >
>> > Hi,
>> >
>> > Is there any way to format all dates generated by a MySQL query as US
>> > format? What I want to do is having a generic way to use the DATE_FORM=
AT
>> > function on all my date fields, instead of having to enter them manual=
ly.
>> > Thank you
>> >
>> > ---
>> > Weydson Lima
>> > weyseal@stripped
>> > http://bluetoothmono.weydson.com
>>
>> ------------------------------
>> The New Busy is not the old busy. Search, chat and e-mail from your inbo=
x. Get
>> started.<http://www.windowslive.com/campaign/thenewbusy?ocid=3DPID28326:=
:T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_3>
>>
>



--=20
 - michael dykman
 - mdykman@stripped

 May the Source be with you.