Re: Converting SQL Microtime to Date and Time
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 46769
interpreted = N
texte = This is how i did it: [text show=F]numDays=[math]floor([thesqlDate]/86400)[/math][/text] [text show=F]theDate=[math date]{1/1/1970}+{0/[numdays]/0}[/math][/text]>I've got a database full of dates in Microtime from PHP and SQL and I need >them in a regular date/time format. Any conversion ideas? > >Thanks > > >-- > > Jesse Williams-Proudman || CEO > NineWire Digital Solutions || +1.888.873.6199 > jesse@ninewire.com || http://ninewire.com >Mac Web Hosting & Colocation || Mac Nationwide Dialup > > Xserve Colocation Special, $75 / Month > http://www.ninewire.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/ -- http://www.dvinci.com/ d'Vinci Interactive------------------------------------------------------------- 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:
This is how i did it: [text show=F]numDays=[math]floor([thesqlDate]/86400)[/math][/text] [text show=F]theDate=[math date]{1/1/1970}+{0/[numdays]/0}[/math][/text]>I've got a database full of dates in Microtime from PHP and SQL and I need >them in a regular date/time format. Any conversion ideas? > >Thanks > > >-- > > Jesse Williams-Proudman || CEO > NineWire Digital Solutions || +1.888.873.6199 > jesse@ninewire.com || http://ninewire.com >Mac Web Hosting & Colocation || Mac Nationwide Dialup > > Xserve Colocation Special, $75 / Month > http://www.ninewire.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/ -- http://www.dvinci.com/ d'Vinci Interactive------------------------------------------------------------- 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/
sally
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:
Date Search (2004)
WebCat2b15MacPlugin - showing [math] (1997)
Deleteing Based On Dates (2002)
[shownext] not displaying anything but first indices found (2000)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
To brighten your day... (2006)
why is this line in GeneralStore? (1998)
Extended [ConvertChars] (1997)
RE: Discounting prices across a site (1997)
PCS Customer submissions ? (1997)
texta,b,c,d,e (urgent) (2003)
[OT] Am I an Idiot? (2004)
Forms Search Questions (1997)
OT: Let's see your workspace... (2005)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
denied access (1997)
RE: Languages (1997)
Protect (1997)
[WebDNA] Browser types (2010)
NetSplat and WebCat2 (1997)