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_name from bugs, users where bugs.bug_reporter =3D users.user_id order by mydate, mytime DESC Nitai --=20 Tools to energize your business Web Content Management =ABRedakto=BB & eBusiness Systems ComputerOil=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://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:

    
  1. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  2. Re: Date fun with MySQL ( Gary Krockover 2004)
  3. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  4. Re: Date fun with MySQL ( Gary Krockover 2004)
  5. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  6. Re: Date fun with MySQL ( "Sal D'Anna" 2004)
  7. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  8. Re: Date fun with MySQL ( "Sal D'Anna" 2004)
  9. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  10. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  11. Re: Date fun with MySQL ( "Sal D'Anna" 2004)
  12. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  13. Re: Date fun with MySQL ( eLists 2004)
  14. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  15. Re: Date fun with MySQL ( Alain Russell 2004)
  16. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  17. Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
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_name from bugs, users where bugs.bug_reporter =3D users.user_id order by mydate, mytime DESC Nitai --=20 Tools to energize your business Web Content Management =ABRedakto=BB & eBusiness Systems ComputerOil=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://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)