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');
@sqlite.org
Subject: [sqlite] Support for millisecond
Can SQLite support millisecond precision in date time data? I looking at
doc I think so, but it's not clear.
Regards,
Lance Shipman
Product Engineer
Esri
Redlands, CA USA
___
sqlite-users mailing list
Can SQLite support millisecond precision in date time data? I looking at doc I
think so, but it's not clear.
Regards,
Lance Shipman
Product Engineer
Esri
Redlands, CA USA
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
On Jan 8, 2015, at 7:21 PM, Lance Shipman lship...@esri.com wrote:
Can SQLite support millisecond precision in date time data? I looking at doc
I think so, but it's not clear.
There is no 'date time’ data type in SQLite. Feel free to store your time data
as either text or number
On Thu, Jan 8, 2015 at 7:28 PM, Petite Abeille petite.abei...@gmail.com
wrote:
On Jan 8, 2015, at 7:21 PM, Lance Shipman lship...@esri.com wrote:
Can SQLite support millisecond precision in date time data? I looking at
doc I think so, but it's not clear.
There is no 'date time’ data type