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
On Sep 2, 2014, at 9:48 PM, jose isaias cabrera jic...@cinops.xerox.com 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.
On Tue, Sep 2, 2014 at 3:48 PM, jose isaias cabrera jic...@cinops.xerox.com
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 either
Richard Hipp wrote...
On Tue, Sep 2, 2014 at 3:48 PM, jose isaias cabrera
jic...@cinops.xerox.com
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
Petite Abeille wrote...
On Sep 2, 2014, at 9:48 PM, jose isaias cabrera jic...@cinops.xerox.com
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.