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
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
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
> 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
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-
5 matches
Mail list logo