On Mon, Nov 2, 2009 at 1:08 PM, DaleEMoore <daleemo...@gmail.com> wrote:
>
> Thanks David SELECT STRFTIME('%H:%M:%f',62.5,'unixepoch') works great for
> seconds less than 1 day!
>
> I wonder what I should do where the time becomes days, weeks, months, years?
I have no idea why you think it won't work for long time periods
sqlite> SELECT STRFTIME('%H:%M:%f',62.5,'unixepoch');
00:01:02.500
sqlite> SELECT STRFTIME('%H:%M:%f',12345678762.5,'unixepoch');
19:12:42.500
sqlite>
>
> Do you have any suggestions about how to handle:
>
> SELECT STRFTIME('%y-%m-%d.%H:%M:%f',962.5,'unixepoch')
>
> I look forward to hearing from you,
> Dale E. Moore
> --
> View this message in context:
> http://old.nabble.com/SUM%28tripSeconds%29-and-format-output-as-days.hours%3Aminutes%3Aseconds.hundredths--tp26154270p26157787.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
-----------------------------------------------------------------------
Assertions are politics; backing up assertions with evidence is science
=======================================================================
Sent from Madison, WI, United States
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
