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:
Updating product information (2002)
[WriteFile] problems (1997)
Checking for blank form fields (sort of...) (1998)
Weird Math and SV Bad News (1997)
AppleScript question (1997)
tpl pages in dreamweaver (2000)
Make sure I understand this??? (1997)
WebCat2 several catalogs? (1997)
tracking variables across a site... (2000)
sort problems....bug or brain fart? (1997)
Re1000001: Setting up shop (1997)
passing search criteria (1997)
pc (1997)
Truncated text (2006)
Migrating to NT (1997)
Fuzzy on [url] context (1998)
[input] [/input] (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
OT - royalty free images (2002)
[WebDNA] max-age (2016)