Re: [sqlite] Importing date string 'YYYYMMDD'

On 02/04/2012 5:20 AM, Simon Slavin wrote: On 1 Apr 2012, at 6:59am, John McMahon wrote: Thanks Igor (and Simon) That is pretty much the path I was thinking of taking (or possibly externally as I import the data), was just wondering if I had missed something in the

Re: [sqlite] Importing date string 'YYYYMMDD'

On 1 Apr 2012, at 6:59am, John McMahon wrote: > Thanks Igor (and Simon) > > That is pretty much the path I was thinking of taking (or possibly externally > as I import the data), was just wondering if I had missed something in the > date functions. You're welcome.

Re: [sqlite] Importing date string 'YYYYMMDD'

On 01/04/2012 12:34 PM, Igor Tandetnik wrote: John wrote: Can the date time functions in SQLite correctly interpret a date string like '20120331'? No. Recognized formats are documented here: http://sqlite.org/lang_datefunc.html Is there a format or modifier

Re: [sqlite] Importing date string 'YYYYMMDD'

On 1 Apr 2012, at 3:05am, John wrote: > Can the date time functions in SQLite correctly interpret a date string like > '20120331'? Is there a format or modifier that will help the function > interpret/convert that as '2012-03-31'? > > I don't see anything myself at

Re: [sqlite] Importing date string 'YYYYMMDD'

John wrote: > Can the date time functions in SQLite correctly interpret a date string > like '20120331'? No. Recognized formats are documented here: http://sqlite.org/lang_datefunc.html > Is there a format or modifier that will help the function interpret/convert >

[sqlite] Importing date string 'YYYYMMDD'

Hi Can the date time functions in SQLite correctly interpret a date string like '20120331'? Is there a format or modifier that will help the function interpret/convert that as '2012-03-31'? I don't see anything myself at the moment but thought I should ask before working out other