Re: Date fun with MySQL
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58472
interpreted = N
texte = Now I dont get an error anymore, but the [mydate] field appears like raw.I use this:select DATE_FORMAT(bugs.mydate, '%d %m %Y'),bugs.id, users.user_namefrom bugs, userswhere bugs.bug_reporter =3D users.user_idorder by mydate, mytime DESCNitai--=20Tools to energize your businessWeb Content Management =ABRedakto=BB & eBusiness SystemsComputerOil=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66info@computeroil.comhttp://computeroil.com> From: Sal D'Anna
> Reply-To: WebDNA Talk > Date: Thu, 17 Jun 2004 10:12:22 -0700> To: WebDNA Talk > Subject: Re: Date fun with MySQL>=20> What's the error?>=20> Salvatore D'Anna> DotNetNuke Hosting>=20>=20>=20> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of> Nitai @ ComputerOil> Sent: Thursday, June 17, 2004 8:14 AM> To: WebDNA Talk> Subject: Re: Date fun with MySQL>=20> Question:>=20> Somehow this date_format gives me an erorr when doing joins:>=20> select bugs.id, DATE_FORMAT(bugs.mydate, '%d %m %Y'), users.user_name> from bugs, users> where bugs.bug_reporter =3D users.user_id> order by bug_date, bug_time DESC-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Now I dont get an error anymore, but the [mydate] field appears like raw.I use this:select DATE_FORMAT(bugs.mydate, '%d %m %Y'),bugs.id, users.user_namefrom bugs, userswhere bugs.bug_reporter =3D users.user_idorder by mydate, mytime DESCNitai--=20Tools to energize your businessWeb Content Management =ABRedakto=BB & eBusiness SystemsComputerOil=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66info@computeroil.comhttp://computeroil.com> From: Sal D'Anna > Reply-To: WebDNA Talk > Date: Thu, 17 Jun 2004 10:12:22 -0700> To: WebDNA Talk > Subject: Re: Date fun with MySQL>=20> What's the error?>=20> Salvatore D'Anna> DotNetNuke Hosting>=20>=20>=20> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of> Nitai @ ComputerOil> Sent: Thursday, June 17, 2004 8:14 AM> To: WebDNA Talk> Subject: Re: Date fun with MySQL>=20> Question:>=20> Somehow this date_format gives me an erorr when doing joins:>=20> select bugs.id, DATE_FORMAT(bugs.mydate, '%d %m %Y'), users.user_name> from bugs, users> where bugs.bug_reporter =3D users.user_id> order by bug_date, bug_time DESC-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Nitai @ ComputerOil"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Permissions (2000)
can WC render sites out? (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[OT]R E: [WebDNA] UPS integration (2010)
2 databases problem (1997)
[WebDNA] directory protection questions (2008)
Email Formatting (1998)
Ampersand (1997)
Replacing entry (1998)
Problem displaying search result (1997)
Re:quit command on NT (1997)
911: testing if the field is empty (2000)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
international time (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
HomePage Caution (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
send mail problem? (1997)
type 2 errors with ssl server (1997)