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 date
functions.
You're
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. Since you haven't imported
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 that will help the function in
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 the moment but thought I sh
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
> that as '2012-03-31'?
Well,
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 solutions.
6 matches
Mail list logo