Re: [sqlite] Support for millisecond

2015-01-08 Thread Stephan Beal
On Fri, Jan 9, 2015 at 12:15 AM, Keith Medcalf 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:1

Re: [sqlite] Support for millisecond

2015-01-08 Thread Keith Medcalf
Of Lance Shipman >Sent: Thursday, 8 January, 2015 11:22 >To: sqlite-users@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 Shi

Re: [sqlite] Support for millisecond

2015-01-08 Thread Stephan Beal
On Thu, Jan 8, 2015 at 7:28 PM, Petite Abeille wrote: > > On Jan 8, 2015, at 7:21 PM, Lance Shipman 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 yo

Re: [sqlite] Support for millisecond

2015-01-08 Thread Petite Abeille
> On Jan 8, 2015, at 7:21 PM, Lance Shipman 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. To whatever precision

[sqlite] Support for millisecond

2015-01-08 Thread Lance Shipman
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-