Re: [sqlite] Selecting dates...

2014-09-02 Thread jose isaias cabrera
"Petite Abeille" wrote... On Sep 2, 2014, at 9:48 PM, jose isaias cabrera wrote: Thoughts? Thanks. SQLite doesn’t have date per se. You are free to store dates as either text or number, or anything you please. But it’s your responsibility to keep it straight.

Re: [sqlite] Selecting dates...

2014-09-02 Thread jose isaias cabrera
"Richard Hipp" wrote... On Tue, Sep 2, 2014 at 3:48 PM, jose isaias cabrera

Re: [sqlite] Selecting dates...

2014-09-02 Thread Richard Hipp
On Tue, Sep 2, 2014 at 3:48 PM, jose isaias cabrera wrote: > > Greetings! > > I know that SQLite dates are of the form -MM-DD and I like that. :-) > I want to find out why these are working. > SQLite does not have a special "date" type. SQLite stores dates as

Re: [sqlite] Selecting dates...

2014-09-02 Thread Petite Abeille
On Sep 2, 2014, at 9:48 PM, jose isaias cabrera wrote: > Thoughts? Thanks. SQLite doesn’t have date per se. You are free to store dates as either text or number, or anything you please. But it’s your responsibility to keep it straight.

[sqlite] Selecting dates...

2014-09-02 Thread jose isaias cabrera
Greetings! I know that SQLite dates are of the form -MM-DD and I like that. :-) I want to find out why these are working. create table t (a date, val integer); insert into t values ('2010-01-01', 10); insert into t values ('2010-1-1', 10); insert into t values ('2010-1-01', 10); insert