mailing list <sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] SQLite - Interrogate Date/Time field Statement question
STOP SPAMM ING ING ME ASS FACE
From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of
lite] SQLite - Interrogate Date/Time field Statement question
This code:
SELECT ( substr('02/13/2016',7,4) || '-'
|| substr('02/13/2016',1,2) || '-'
|| substr('02/13/2016',4,2) ) ;
yields
2016-02-13
The above code, is dependent on fixed length strings (the leading zero) in
other words
/Time field Statement question
On 2017/04/12 3:08 PM, Ron Barnes wrote:
> Hello Ryan,
>
> That Code below worked as you said it should. Awesome! And Thank you!
>
> I now have the days difference for each row.
>
> I have one other question if I may pose it to you, how
On 2017/04/12 3:50 PM, Paul Sanderson wrote:
another oops I see Ryan pretty much posted the same as me 5 minutes earlier
- I'll go back to bed :)
The more the merrier I say.
There is no guarantee I am right, and seeing the problem solved in more
than one way usually helps the poster - which
On 2017/04/12 3:08 PM, Ron Barnes wrote:
Hello Ryan,
That Code below worked as you said it should. Awesome! And Thank you!
I now have the days difference for each row.
I have one other question if I may pose it to you, how do I count the number of
rows, less than a day, or a week or a year
ite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of R Smith
> Sent: Wednesday, April 12, 2017 8:32 AM
> To: sqlite-users@mailinglists.sqlite.org
> Subject: Re: [sqlite] SQLite - Interrogate Date/Time field Statement
> question
>
>
> On 2017/04/12 2:13 PM, Ron Barnes wro
Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of R Smith
> Sent: Wednesday, April 12, 2017 8:32 AM
> To: sqlite-users@mailinglists.sqlite.org
> Subject: Re: [sqlite] SQLite - Interrogate Date/Time field Statemen
@mailinglists.sqlite.org] On
Behalf Of R Smith
Sent: Wednesday, April 12, 2017 8:32 AM
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] SQLite - Interrogate Date/Time field Statement question
On 2017/04/12 2:13 PM, Ron Barnes wrote:
> Hi Jim,
>
> I ran an overnight job
gt;> -Ron
>>
>> -Original Message-
>> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
>> On Behalf Of Jim Callahan
>> Sent: Tuesday, April 11, 2017 11:22 PM
>> To: SQLite mailing list <sqlite-users@mailinglists.sqlite.o
> On Behalf Of Jim Callahan
> Sent: Tuesday, April 11, 2017 11:22 PM
> To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
> Subject: Re: [sqlite] SQLite - Interrogate Date/Time field Statement
> question
>
> This code:
>
> SELECT ( substr('02
On 2017/04/12 2:13 PM, Ron Barnes wrote:
Hi Jim,
I ran an overnight job and converted 300+ million dates to the ISO 8601 format.
Here are examples of the new dates.
2017/04/10 07:24:15 PM
2017/03/07 08:08:58 AM
2016/11/06 12:35:15 PM
Since this should be easier how
-users@mailinglists.sqlite.org
Subject: Re: [sqlite] SQLite - Interrogate Date/Time field Statement question
On 2017/04/12 1:24 AM, Ron Barnes wrote:
> Hello all,
>
> To everyone who helped me before - thank you very much!
>
> I'm coding in Visual Basic .NET (Visual Studio 2015) Commun
ct: Re: [sqlite] SQLite - Interrogate Date/Time field Statement question
This code:
SELECT ( substr('02/13/2016',7,4) || '-'
|| substr('02/13/2016',1,2) || '-'
|| substr('02/13/2016',4,2) ) ;
yields
2016-02-13
The above code, is dependent on fixed length strings (the leadin
Mailer messed up the format on a very important space... retry:
-- Script Items: 4 Parameter Count: 0
-- 2017-04-12 13:43:15.875 | [Info] Script Initialized,
Started executing...
--
On 2017/04/12 1:24 AM, Ron Barnes wrote:
Hello all,
To everyone who helped me before - thank you very much!
I'm coding in Visual Basic .NET (Visual Studio 2015) Community.
I have to count a Date/Time field and the problem is, this field contains data
in a format I'm not sure can be
t; Side note, I'll be visiting Disney in July!
>
> Regards,
>
> -Ron
>
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of Jim Callahan
> Sent: Tuesday, April 11, 2017 9:15 PM
> To: SQLite mailing list <
sqlite] SQLite - Interrogate Date/Time field Statement question
Can you convert the dates to ISO 8601 date time format?
https://en.wikipedia.org/wiki/ISO_8601
-MM-DD hh:mm:ss
ISO date strings (when zero filled) are sortable which necessarily includes
comparable (Java speak).
By "zero fil
Can you convert the dates to ISO 8601 date time format?
https://en.wikipedia.org/wiki/ISO_8601
-MM-DD hh:mm:ss
ISO date strings (when zero filled) are sortable which necessarily includes
comparable (Java speak).
By "zero filled" I mean for March you have "03" and not just "3".
Then if you
Hello all,
To everyone who helped me before - thank you very much!
I'm coding in Visual Basic .NET (Visual Studio 2015) Community.
I have to count a Date/Time field and the problem is, this field contains data
in a format I'm not sure can be counted.
I need to count all the dates in the field
19 matches
Mail list logo