Re: [sqlite] TRIM Function in Python3's sqlite3 import

2017-12-24 Thread Ed Lipson
ks like trim was added in 10 years ago in 3.4.0 (2007-06-18) Can't help you with the Linux side of things, sorry. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Ed Lipson --cut-- Thanks, Ed

[sqlite] TRIM Function in Python3's sqlite3 import

2017-12-22 Thread Ed Lipson
I shifting some Python code to Linux from Windows. I find that TRIN i smissing from the verison on Linux. Python reports this version information sqlite.version 2.6.0 for both Windows and Linux sqlite.sqlite_version 3.3.6 for Linux, 3.15.2 for Windows. Two questions: 1. When was TRIM added as a

[sqlite] Date Formatting from Excel Float Date/Time Representation

2017-01-06 Thread Ed Lipson
I'm trying to work with JIRA information. I export my JIRA records and load them into a SQLite3 database via a python script. The export is in Excel format. When I send the data back from SQLite3 to Excel and have Excel format the date, it is correctly interpreted. From that I am assuming I have a