Changing date result automatically

--001636025ff0ad30770485efa94a
Content-Type: text/plain; charset=ISO-8859-1

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_FORMAT
function on all my date fields, instead of having to enter them manually.
Thank you

---
Weydson Lima
weyseal@gmail.com
http://bluetoothmono.weydson.com

--001636025ff0ad30770485efa94a--

Re: Changing date result automatically

--00c09f8e5de775d44c0485f33ee9
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I was referring to the function:

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functio ns.html#functio=
n_date-format

---
Weydson Lima
weyseal@gmail.com


On Thu, May 6, 2010 at 1:58 PM, Martin Gainty wrote:

> http://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 confidentialit=
=E9
>
> Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene
> Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugt=
e
> Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht
> 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'=EAt=
es pas le destinataire pr=E9vu, nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation, =
nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni.
>
>
>
>
>
>
> > From: weyseal@gmail.com
> > Date: Thu, 6 May 2010 11:44:37 -0500
> > Subject: Changing date result automatically
> > To: mysql@lists.mysql.com
>
> >
> > 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_FORMA=
T
> > function on all my date fields, instead of having to enter them manuall=
y.
> > Thank you
> >
> > ---
> > Weydson Lima
> > weyseal@gmail.com
> > http://bluetoothmono.weydson.com
>
> ------------------------------
> The New Busy is not the old busy. Search, chat and e-mail from your inbox=
.. Get
> started. T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_3>
>

--00c09f8e5de775d44c0485f33ee9--

Re: Changing date result automatically

--001485eaffd86669b70485fc91ed
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Dates are not internally stored as a specific region format, they're stored
as seconds since epoch - just a big number.

Output formatting is a presentation layer issue, which you can solve either
in your SQL [select date_format(datefield, 'us format string') from table]
or in your application.

Maybe MySQL looks at the system's locale for default formatting, or there's
a config setting, but I've never looked at that - doing it explicitly
protects you from annoying glitches when you move to another system that
might be configured slightly differently.


On Thu, May 6, 2010 at 11:00 PM, Weydson Lima wrote:

> I was referring to the function:
>
>
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functio ns.html#funct=
ion_date-format
>
> ---
> Weydson Lima
> weyseal@gmail.com
>
>
> On Thu, May 6, 2010 at 1:58 PM, Martin Gainty wrote=
:
>
> > http://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 confidential=
it=E9
> >
> > Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene
> > Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede
> unbefugte
> > Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachric=
ht
> > 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'=
=EAtes pas
> le destinataire pr=E9vu, nous te demandons avec bont=E9 que pour satisfai=
re
> informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e ou la=
copie
> de ceci est interdite. Ce message sert =E0 l'information seulement et n'a=
ura
> pas n'importe quel effet l=E9galement obligatoire. =C9tant donn=E9 que le=
s email
> peuvent facilement =EAtre sujets =E0 la manipulation, nous ne pouvons acc=
epter
> aucune responsabilit=E9 pour le contenu fourni.
> >
> >
> >
> >
> >
> >
> > > From: weyseal@gmail.com
> > > Date: Thu, 6 May 2010 11:44:37 -0500
> > > Subject: Changing date result automatically
> > > To: mysql@lists.mysql.com
> >
> > >
> > > 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_FORMAT
> > > function on all my date fields, instead of having to enter them
> manually.
> > > Thank you
> > >
> > > ---
> > > Weydson Lima
> > > weyseal@gmail.com
> > > http://bluetoothmono.weydson.com
> >
> > ------------------------------
> > The New Busy is not the old busy. Search, chat and e-mail from your
> inbox. Get
> > started.<
> http://www.windowslive.com/campaign/thenewbusy?ocid=3DPID283 26::T:WLMTAGL=
:ON:WL:en-US:WM_HMP:042010_3
> >
> >
>



--=20
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--001485eaffd86669b70485fc91ed--

Re: Re: Changing date result automatically

--001485f85e64c43596048602fb20
Content-Type: text/plain; charset=ISO-8859-1; format=flowed; delsp=yes
Content-Transfer-Encoding: base64

VGhhbmsgeW91IGZvciB5b3VyIGV4cGxhbmF0aW9uLiBJIHdhcyBqdXN0IGN1 cmlvdXMgaWYgdGhl
cmUgd2FzIGFuICJlYXN5IiAgDQp3YXkgdG8gZm9ybWF0IHRoZSBvdXRwdXQg b2YgdGhlIGRhdGVz
Li4gbWF5YmUgYnkgdXNpbmcgYSB3aWxkY2FyZCAgDQpleHByZXNzaW9uIG9u IHRoZSBmaWVsZCBu
YW1lcyA6KQ0KDQoNCldleWRzb24gTGltYQ0KDQpPbiBNYXkgNywgMjAxMCAz OjA4YW0sIEpvaGFu
IERlIE1lZXJzbWFuIDx2ZWdpdmFtcEB0dXhlcmEuYmU+IHdyb3RlOg0KPiBE YXRlcyBhcmUgbm90
IGludGVybmFsbHkgc3RvcmVkIGFzIGEgc3BlY2lmaWMgcmVnaW9uIGZvcm1h dCwgdGhleSdyZSAg
DQo+IHN0b3JlZCBhcyBzZWNvbmRzIHNpbmNlIGVwb2NoIC0ganVzdCBhIGJp ZyBudW1iZXIuDQoN
Cj4gT3V0cHV0IGZvcm1hdHRpbmcgaXMgYSBwcmVzZW50YXRpb24gbGF5ZXIg aXNzdWUsIHdoaWNo
IHlvdSBjYW4gc29sdmUgIA0KPiBlaXRoZXIgaW4geW91ciBTUUwgW3NlbGVj dCBkYXRlX2Zvcm1h
dChkYXRlZmllbGQsICd1cyBmb3JtYXQgc3RyaW5nJykgIA0KPiBmcm9tIHRh YmxlXSBvciBpbiB5
b3VyIGFwcGxpY2F0aW9uLg0KDQoNCg0KPiBNYXliZSBNeVNRTCBsb29rcyBh dCB0aGUgc3lzdGVt
J3MgbG9jYWxlIGZvciBkZWZhdWx0IGZvcm1hdHRpbmcsIG9yICANCj4gdGhl cmUncyBhIGNvbmZp
ZyBzZXR0aW5nLCBidXQgSSd2ZSBuZXZlciBsb29rZWQgYXQgdGhhdCAtIGRv aW5nIGl0ICANCj4g
ZXhwbGljaXRseSBwcm90ZWN0cyB5b3UgZnJvbSBhbm5veWluZyBnbGl0Y2hl cyB3aGVuIHlvdSBt
b3ZlIHRvIGFub3RoZXIgIA0KPiBzeXN0ZW0gdGhhdCBtaWdodCBiZSBjb25m aWd1cmVkIHNsaWdo
dGx5IGRpZmZlcmVudGx5Lg0KDQoNCg0KDQo+IE9uIFRodSwgTWF5IDYsIDIw MTAgYXQgMTE6MDAg
UE0sIFdleWRzb24gTGltYSB3ZXlzZWFsQGdtYWlsLmNvbT4gd3JvdGU6DQoN Cg0KPiBJIHdhcyBy
ZWZlcnJpbmcgdG8gdGhlIGZ1bmN0aW9uOg0KDQoNCg0KDQoNCj4gaHR0cDov L2Rldi5teXNxbC5j
b20vZG9jL3JlZm1hbi81LjEvZW4vZGF0ZS1hbmQtdGltZS1mdW5jdGlvbnMu aHRtbCNmdW5jdGlv
bl9kYXRlLWZvcm1hdA0KDQoNCg0KDQoNCj4gLS0tDQoNCg0KPiBXZXlkc29u IExpbWENCg0KDQo+
IHdleXNlYWxAZ21haWwuY29tDQoNCg0KDQoNCg0KDQoNCg0KDQo+IE9uIFRo dSwgTWF5IDYsIDIw
MTAgYXQgMTo1OCBQTSwgTWFydGluIEdhaW50eSBtZ2FpbnR5QGhvdG1haWwu Y29tPiB3cm90ZToN
Cg0KDQoNCg0KDQo+ID4gaHR0cDovL2xpc3RzLm15c3FsLmNvbS9jb21taXRz LzYwODM0DQoNCg0K
PiA+DQoNCg0KPiA+IGRhdGVfZm9ybWF0IHN5c3RlbSB2YXJpYWJsZSBpcyBj dXJyZW50bHkgYW4g
dW51c2VkIHN5c3RlbSB2YXJpYWJsZQ0KDQoNCj4gPg0KDQoNCj4gPiBNYXJ0 aW4gR2FpbnR5DQoN
Cg0KPiA+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX18NCg0K
DQo+ID4gVmVyemljaHQgdW5kIFZlcnRyYXVsaWNoa2VpdGFubWVya3VuZy9O b3RlIGRlIGTpbmkg
ZXQgZGUgY29uZmlkZW50aWFsaXTpDQoNCg0KPiA+DQoNCg0KPiA+IERpZXNl IE5hY2hyaWNodCBp
c3QgdmVydHJhdWxpY2guIFNvbGx0ZW4gU2llIG5pY2h0IGRlciB2b3JnZXNl aGVuZQ0KDQoNCj4g
PiBFbXBmYWVuZ2VyIHNlaW4sIHNvIGJpdHRlbiB3aXIgaG9lZmxpY2ggdW0g ZWluZSBNaXR0ZWls
dW5nLiBKZWRlICANCj4gdW5iZWZ1Z3RlDQoNCg0KPiA+IFdlaXRlcmxlaXR1 bmcgb2RlciBGZXJ0
aWd1bmcgZWluZXIgS29waWUgaXN0IHVuenVsYWVzc2lnLiBEaWVzZSAgDQo+ IE5hY2hyaWNodA0K
DQoNCj4gPiBkaWVudCBsZWRpZ2xpY2ggZGVtIEF1c3RhdXNjaCB2b24gSW5m b3JtYXRpb25lbiB1
bmQgZW50ZmFsdGV0IGtlaW5lDQoNCg0KPiA+IHJlY2h0bGljaGUgQmluZHVu Z3N3aXJrdW5nLiBB
dWZncnVuZCBkZXIgbGVpY2h0ZW4gTWFuaXB1bGllcmJhcmtlaXQgdm9uDQoN Cg0KPiA+IEUtTWFp
bHMga29lbm5lbiB3aXIga2VpbmUgSGFmdHVuZyBmdWVyIGRlbiBJbmhhbHQg dWViZXJuZWhtZW4u
DQoNCg0KPiA+DQoNCg0KPiA+IENlIG1lc3NhZ2UgZXN0IGNvbmZpZGVudGll bCBldCBwZXV0IOp0
cmUgcHJpdmls6Wdp6S4gU2kgdm91cyBuJ+p0ZXMgcGFzICANCj4gbGUgZGVz dGluYXRhaXJlIHBy
6XZ1LCBub3VzIHRlIGRlbWFuZG9ucyBhdmVjIGJvbnTpIHF1ZSBwb3VyIHNh dGlzZmFpcmUgIA0K
PiBpbmZvcm1leiBsJ2V4cOlkaXRldXIuIE4naW1wb3J0ZSBxdWVsbGUgZGlm ZnVzaW9uIG5vbiBh
dXRvcmlz6WUgb3UgbGEgIA0KPiBjb3BpZSBkZSBjZWNpIGVzdCBpbnRlcmRp dGUuIENlIG1lc3Nh
Z2Ugc2VydCDgIGwnaW5mb3JtYXRpb24gc2V1bGVtZW50IGV0ICANCj4gbidh dXJhIHBhcyBuJ2lt
cG9ydGUgcXVlbCBlZmZldCBs6WdhbGVtZW50IG9ibGlnYXRvaXJlLiDJdGFu dCBkb25u6SBxdWUg
IA0KPiBsZXMgZW1haWwgcGV1dmVudCBmYWNpbGVtZW50IOp0cmUgc3VqZXRz IOAgbGEgbWFuaXB1
bGF0aW9uLCBub3VzIG5lICANCj4gcG91dm9ucyBhY2NlcHRlciBhdWN1bmUg cmVzcG9uc2FiaWxp
dOkgcG91ciBsZSBjb250ZW51IGZvdXJuaS4NCg0KDQoNCg0KPiA+DQoNCg0K PiA+DQoNCg0KPiA+
DQoNCg0KPiA+DQoNCg0KPiA+DQoNCg0KPiA+DQoNCg0KPiA+ID4gRnJvbTog d2V5c2VhbEBnbWFp
bC5jb20NCg0KDQo+ID4gPiBEYXRlOiBUaHUsIDYgTWF5IDIwMTAgMTE6NDQ6 MzcgLTA1MDANCg0K
DQo+ID4gPiBTdWJqZWN0OiBDaGFuZ2luZyBkYXRlIHJlc3VsdCBhdXRvbWF0 aWNhbGx5DQoNCg0K
PiA+ID4gVG86IG15c3FsQGxpc3RzLm15c3FsLmNvbQ0KDQoNCg0KPiA+DQoN Cg0KPiA+ID4NCg0K
DQo+ID4gPiBIaSwNCg0KDQo+ID4gPg0KDQoNCj4gPiA+IElzIHRoZXJlIGFu eSB3YXkgdG8gZm9y
bWF0IGFsbCBkYXRlcyBnZW5lcmF0ZWQgYnkgYSBNeVNRTCBxdWVyeSBhcyBV Uw0KDQoNCj4gPiA+
IGZvcm1hdD8gV2hhdCBJIHdhbnQgdG8gZG8gaXMgaGF2aW5nIGEgZ2VuZXJp YyB3YXkgdG8gdXNl
IHRoZSAgDQo+IERBVEVfRk9STUFUDQoNCg0KPiA+ID4gZnVuY3Rpb24gb24g YWxsIG15IGRhdGUg
ZmllbGRzLCBpbnN0ZWFkIG9mIGhhdmluZyB0byBlbnRlciB0aGVtICANCj4g bWFudWFsbHkuDQoN
Cg0KPiA+ID4gVGhhbmsgeW91DQoNCg0KPiA+ID4NCg0KDQo+ID4gPiAtLS0N Cg0KDQo+ID4gPiBX
ZXlkc29uIExpbWENCg0KDQo+ID4gPiB3ZXlzZWFsQGdtYWlsLmNvbQ0KDQoN Cj4gPiA+IGh0dHA6
Ly9ibHVldG9vdGhtb25vLndleWRzb24uY29tDQoNCg0KPiA+DQoNCg0KDQoN Cj4gPiAtLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCg0KDQo+ID4gVGhlIE5ldyBCdXN5 IGlzIG5vdCB0aGUg
b2xkIGJ1c3kuIFNlYXJjaCwgY2hhdCBhbmQgZS1tYWlsIGZyb20geW91ciAg DQo+IGluYm94LiBH
ZXQNCg0KDQo+ID4gIA0KPiBzdGFydGVkLmh0dHA6Ly93d3cud2luZG93c2xp dmUuY29tL2NhbXBh
aWduL3RoZW5ld2J1c3k/b2NpZD1QSUQyODMyNjo6VDpXTE1UQUdMOk9OOldM OmVuLVVTOldNX0hN
UDowNDIwMTBfMz4NCg0KDQoNCg0KPiA+DQoNCg0KDQoNCg0KPiAtLQ0KPiBC aWVyIG1ldCBncmVu
YWR5bg0KPiBJcyBhbHMgbW9zdGVyZCBieSBkZW4gd3luDQo+IFN5IGRpZSd0 IGRyaW5rdCwgaXMg
ZWVuZSBrd2V6ZWwNCj4gSHkgZGllJ3QgZHJpbmt0LCBpcyByYXMgZWVuIGV6 ZWwNCg0KDQoNCg==
--001485f85e64c43596048602fb20--

Re: Changing date result automatically

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 wrote:
> I was referring to the function:
>
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functio ns.html#funct=
ion_date-format
>
> ---
> Weydson Lima
> weyseal@gmail.com
>
>
> On Thu, May 6, 2010 at 1:58 PM, Martin Gainty 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@gmail.com
>> > Date: Thu, 6 May 2010 11:44:37 -0500
>> > Subject: Changing date result automatically
>> > To: mysql@lists.mysql.com
>>
>> >
>> > 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@gmail.com
>> > http://bluetoothmono.weydson.com
>>
>> ------------------------------
>> The New Busy is not the old busy. Search, chat and e-mail from your inbo=
x. Get
>> started. :T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_3>
>>
>



--=20
- michael dykman
- mdykman@gmail.com

May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg