On Fri, Jan 9, 2015 at 12:15 AM, Keith Medcalf <kmedc...@dessus.com> wrote:
>
> You mean iso-8601 strings in the database? Yes, you can format the
> strings however you want (ie with an ...
> ...
sqlite> select strftime('%Y-%m-%d %H:%M:%f', '2015-02-14
> 13:46:15.3948573647856354765 +04:00');
> 2015-02-14 09:46:15.394
>
i should have been careful to note that i was using custom conversions
(based on Wikipedia and its outbound links), as opposed to sqlite's
methods, and using ms precision for the ISO strings.
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
