Re: Date fun with MySQL
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58471
interpreted = N
texte = What's the error?Salvatore D'AnnaDotNetNuke Hosting-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf OfNitai @ ComputerOilSent: Thursday, June 17, 2004 8:14 AMTo: WebDNA TalkSubject: Re: Date fun with MySQLQuestion:Somehow this date_format gives me an erorr when doing joins:select bugs.id, DATE_FORMAT(bugs.mydate, '%d %m %Y'), users.user_namefrom bugs, userswhere bugs.bug_reporter = users.user_idorder by bug_date, bug_time DESCI have looked online but could not find any answers.Nitai--Redakto - Content Management that simply worksContent Management & eBusiness SystemsComputerOilR 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 07:37:37 -0700> To: WebDNA Talk > Subject: Re: Date fun with MySQL> > The format of a DATE value is 'YYYY-MM-DD'. According to standard SQL, no> other format is allowed. You should use this format in UPDATE expressions> and in the WHERE clause of SELECT statements. For example:> > EXAMPLE> SELECT * FROM tbl_name WHERE date >= '2003-05-05';> > > To display in different formats, tell MySQL to format the date when you do> your select statement and then it will show up nicely formatted (using> DATE_FORMAT) ...> > EXAMPLE> SELECT DATE_FORMAT(column_name, '%M %e %Y') FROM tbl_name;> > > > Salvatore D'Anna> DotNetNuke Hosting> > > -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of> Nitai @ ComputerOil> Sent: Thursday, June 17, 2004 2:39 AM> To: WebDNA Talk> Subject: Re: Date fun with MySQL> > Alain my man:-)> > I figured that saving them in native format will keep the DB save forother> applications.> > But what about if we need to show them in other formats. Each of my hosts> want to have different date formats. No I am not using sandboxes :-)> > Is there any way to achieve this, like the good old [format] tag withMySql> date fields?> > Nitai> > --> Redakto - Content Management that simply works> Content Management & eBusiness Systems> > ComputerOilR AG> Dammstrasse 7> 5400 Baden / Switzerland> Telefon +41 (0)844 44 55 66> > info@computeroil.com> http://computeroil.com> > > >> From: Alain Russell >> Reply-To: WebDNA Talk >> Date: Thu, 17 Jun 2004 21:28:15 +1200>> To: WebDNA Talk >> Subject: Re: Date fun with MySQL>> >> I'd save them in native MySQL Date format.>> >> They will then be fast for searching and I'm guessing at a later date>> SMSI will add a function to read/change dates from MySQL format to>> WebDNA format as an option.>> >> As well you will be able to access the database with other applications>> (PHP) that will not need to many workarounds to read/write the date.>> >> Alain>> >> On 17/06/2004, at 5:53 PM, Nitai @ ComputerOil wrote:>> >>> Hi guys,>>> >>> No one working with MySQL and WebDNA? I can't ask that question no>>> where>>> else, since no one knnows WebDNA ..........>>> >>> Nitai>> >> >> >> ------------------------------------------------------------->> 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/>> > > > > > -------------------------------------------------------------> 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/> > __________ NOD32 1.789 (20040614) Information __________> > This message was checked by NOD32 Antivirus System.> http://www.nod32.com> > > > -------------------------------------------------------------> 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/> -------------------------------------------------------------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 toWeb Archive of this list is at: http://webdna.smithmicro.com/__________ NOD32 1.789 (20040614) Information __________This message was checked by NOD32 Antivirus System.http://www.nod32.com-------------------------------------------------------------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:
What's the error?Salvatore D'AnnaDotNetNuke Hosting-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf OfNitai @ ComputerOilSent: Thursday, June 17, 2004 8:14 AMTo: WebDNA TalkSubject: Re: Date fun with MySQLQuestion:Somehow this date_format gives me an erorr when doing joins:select bugs.id, DATE_FORMAT(bugs.mydate, '%d %m %Y'), users.user_namefrom bugs, userswhere bugs.bug_reporter = users.user_idorder by bug_date, bug_time DESCI have looked online but could not find any answers.Nitai--Redakto - Content Management that simply worksContent Management & eBusiness SystemsComputerOilR 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 07:37:37 -0700> To: WebDNA Talk > Subject: Re: Date fun with MySQL> > The format of a DATE value is 'YYYY-MM-DD'. According to standard SQL, no> other format is allowed. You should use this format in UPDATE expressions> and in the WHERE clause of SELECT statements. For example:> > EXAMPLE> SELECT * FROM tbl_name WHERE date >= '2003-05-05';> > > To display in different formats, tell MySQL to format the date when you do> your select statement and then it will show up nicely formatted (using> DATE_FORMAT) ...> > EXAMPLE> SELECT DATE_FORMAT(column_name, '%M %e %Y') FROM tbl_name;> > > > Salvatore D'Anna> DotNetNuke Hosting> > > -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of> Nitai @ ComputerOil> Sent: Thursday, June 17, 2004 2:39 AM> To: WebDNA Talk> Subject: Re: Date fun with MySQL> > Alain my man:-)> > I figured that saving them in native format will keep the DB save forother> applications.> > But what about if we need to show them in other formats. Each of my hosts> want to have different date formats. No I am not using sandboxes :-)> > Is there any way to achieve this, like the good old [format] tag withMySql> date fields?> > Nitai> > --> Redakto - Content Management that simply works> Content Management & eBusiness Systems> > ComputerOilR AG> Dammstrasse 7> 5400 Baden / Switzerland> Telefon +41 (0)844 44 55 66> > info@computeroil.com> http://computeroil.com> > > >> From: Alain Russell >> Reply-To: WebDNA Talk >> Date: Thu, 17 Jun 2004 21:28:15 +1200>> To: WebDNA Talk >> Subject: Re: Date fun with MySQL>> >> I'd save them in native MySQL Date format.>> >> They will then be fast for searching and I'm guessing at a later date>> SMSI will add a function to read/change dates from MySQL format to>> WebDNA format as an option.>> >> As well you will be able to access the database with other applications>> (PHP) that will not need to many workarounds to read/write the date.>> >> Alain>> >> On 17/06/2004, at 5:53 PM, Nitai @ ComputerOil wrote:>> >>> Hi guys,>>> >>> No one working with MySQL and WebDNA? I can't ask that question no>>> where>>> else, since no one knnows WebDNA ..........>>> >>> Nitai>> >> >> >> ------------------------------------------------------------->> 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/>> > > > > > -------------------------------------------------------------> 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/> > __________ NOD32 1.789 (20040614) Information __________> > This message was checked by NOD32 Antivirus System.> http://www.nod32.com> > > > -------------------------------------------------------------> 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/> -------------------------------------------------------------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 toWeb Archive of this list is at: http://webdna.smithmicro.com/__________ NOD32 1.789 (20040614) Information __________This message was checked by NOD32 Antivirus System.http://www.nod32.com-------------------------------------------------------------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/
"Sal D'Anna"
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:
template includes encrypted template (1999)
PIXO support (1997)
$Replace with [founditems] (1997)
Search wbrk word break param (1998)
Announcement-WebCatalog 2.0 Released (1997)
WebCatalog 2.0 b 15 mac (1997)
WebCat2b13 Command Reference Doc error (1997)
Using Cookie for client specific info? (1997)
Trigger options (2000)
Where's Cart Created ? (1997)
Search Questions (2000)
test (2004)
WCS Newbie question (1997)
Can [writefile] files be served thru webcat? (2000)
The 10 Mistakes Most Men Make With Women (2006)
Why do extra quotation marks sometimes appear in my databases? (1998)
FYI: virus alert (1996)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Email Set-Up? (1997)
Number of Line Items (1998)