Re: Converting SQL Microtime to Date and Time
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 46770
interpreted = N
texte = I'm with Frank; never heard of Microtime...but this page has helped me to understand a little better:http://www.php.net/manual/en/function.microtime.phpI know this doesn't help you at all, Jesse, but could you post a sample of the Microtime you're dealing with so I can see what it looks like. If I understand it correctly, it would be, like 253425435243263426354237156243715624371 or something for yesterday (just kidding, math wiz's out there).Thanks,------------------------------------------------------------http://www.StrongGraphicDesign.com(208) 319-0137 | Toll-free p/f 877-561-1656------------------------------------------------------------On Thu, 09 Jan 2003 04:46:30 Frank Nordberg
wrote:>>>Jesse Williams-Proudman wrote:>>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?>>What is Microtime?>>>Frank Nordberg>http://www.musicaviva.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 to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I'm with Frank; never heard of Microtime...but this page has helped me to understand a little better:http://www.php.net/manual/en/function.microtime.phpI know this doesn't help you at all, Jesse, but could you post a sample of the Microtime you're dealing with so I can see what it looks like. If I understand it correctly, it would be, like 253425435243263426354237156243715624371 or something for yesterday (just kidding, math wiz's out there).Thanks,------------------------------------------------------------http://www.StrongGraphicDesign.com(208) 319-0137 | Toll-free p/f 877-561-1656------------------------------------------------------------On Thu, 09 Jan 2003 04:46:30 Frank Nordberg wrote:>>>Jesse Williams-Proudman wrote:>>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?>>What is Microtime?>>>Frank Nordberg>http://www.musicaviva.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 to Web Archive of this list is at: http://webdna.smithmicro.com/
Dan Strong
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:
WordBreak Qestion (1998)
[WebDNA] Does anyone host webdna sites? (2016)
form data submission gets truncated (1997)
WebCat.acgi from /cgi-bin/? (1997)
Locking up with WebCatalog... (1997)
returning the missing value (1997)
[WebDNA] Does WebDNA run on Ubuntu 16.04? (2016)
[WebDNA] WebDNA 7 (2011)
creating a 60 fields database (1997)
Nested tags count question (1997)
Getting total number of items ordered (1997)
Appending current [date] to a database (1997)
Sorting by highest number of matches unique to a field (2003)
WebCat2 - [SendNews] (1997)
[SHOWIF]s and empty arguments (1997)
Results table formatting (2003)
Searching for all records (1998)
More on the email templates (1997)
Simple way to create unique SKU (1997)
[WebDNA] [replace] bug in v7.0? (2010)