"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.
"Richard Hipp" wrote...
On Tue, Sep 2, 2014 at 3:48 PM, jose isaias cabrera
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
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.
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
5 matches
Mail list logo