Re: Date fun with MySQL
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58465
interpreted = N
texte = Alain my man:-)I figured that saving them in native format will keep the DB save for otherapplications.But what about if we need to show them in other formats. Each of my hostswant to have different date formats. No I am not using sandboxes :-)Is there any way to achieve this, like the good old [format] tag with MySqldate fields?Nitai--Redakto - Content Management that simply worksContent Management & eBusiness SystemsComputerOil=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66info@computeroil.comhttp://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>=20> I'd save them in native MySQL Date format.>=20> 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.>=20> 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.>=20> Alain>=20> On 17/06/2004, at 5:53 PM, Nitai @ ComputerOil wrote:>=20>> Hi guys,>>=20>> No one working with MySQL and WebDNA? I can't ask that question no>> where>> else, since no one knnows WebDNA ..........>>=20>> Nitai>=20>=20>=20> -------------------------------------------------------------> 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/>=20-------------------------------------------------------------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:
Alain my man:-)I figured that saving them in native format will keep the DB save for otherapplications.But what about if we need to show them in other formats. Each of my hostswant to have different date formats. No I am not using sandboxes :-)Is there any way to achieve this, like the good old [format] tag with MySqldate fields?Nitai--Redakto - Content Management that simply worksContent Management & eBusiness SystemsComputerOil=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66info@computeroil.comhttp://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>=20> I'd save them in native MySQL Date format.>=20> 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.>=20> 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.>=20> Alain>=20> On 17/06/2004, at 5:53 PM, Nitai @ ComputerOil wrote:>=20>> Hi guys,>>=20>> No one working with MySQL and WebDNA? I can't ask that question no>> where>> else, since no one knnows WebDNA ..........>>=20>> Nitai>=20>=20>=20> -------------------------------------------------------------> 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/>=20-------------------------------------------------------------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:
Shopping Cart Problem (1998)
Trouble with formula.db (1997)
WC1.6 to WC2 date formatting (1997)
no global [username] or [password] displayed ... (1997)
List Name Change Update (2002)
Problem about [CART] number (1998)
Cart Numbers (1997)
Database Structure? (1998)
Buying sans cart (1997)
Help name our technology! I found it (1997)
Paymethod question (1999)
[ShowIf] and empty fields (1997)
Re2: frames & carts (1997)
Criticism of WebCatalog: Keep It Coming! (1998)
WebCat2b15MacPlugin - showing [math] (1997)
Emailer [cart] file names (1997)
simple answer? [hideif] (1997)
Download URL & access on the fly ? (1997)
Secure server question (1997)
Size limit for tmpl editor ? (1997)