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:

    
  1. Re: Converting SQL Microtime to Date and Time (Dan Strong 2003)
  2. Re: Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  3. Re: Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  4. Re: Converting SQL Microtime to Date and Time (Dan Strong 2003)
  5. Re: Converting SQL Microtime to Date and Time (sally 2003)
  6. Re: Converting SQL Microtime to Date and Time (John Peacock 2003)
  7. Re: Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  8. Re: Converting SQL Microtime to Date and Time (Frank Nordberg 2003)
  9. Re: Converting SQL Microtime to Date and Time (Glenn Busbin 2003)
  10. Re: Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
  11. Re: Converting SQL Microtime to Date and Time (Glenn Busbin 2003)
  12. Converting SQL Microtime to Date and Time (Jesse Williams-Proudman 2003)
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)