CODEWITHSUNDEEP
sqlitedatetimedatetimeformat
cja
cja

Reputation: 10016

How to format date and time values for SQLite?

Can't believe I have to ask this here. Even googling didn't help.

I want to do this:

insert into atable (adatefield,atimefield,adatetimefield) values (A,B,C);

What do I put for A, B and C?

It's nice that it's free but the documentation for SQLite is awful.

Upvotes: 1

Views: 7844

Answers (1)

Strahd_za
Strahd_za

Reputation: 218

A date, time and datetime field will actually all store datetime, it just depends on what you insert into it, and they will all work with date strings.

You can 

insert into atable values("2010-11-16","14:12:22","2010-11-16 14:12:22");

or you can actually just insert "2010-11-16 14:12:22" into all the fields and then select them back with:

select date(adatefield), time(atimefield), datetime(adatetimefield) from atable;

If however you want to make sure that the fields only contain exactly a date,time or datetime and you're inserting from variables, then you can 

insert into atable values(date(thedate),time(thedate),datetime(thedate));

Sqlites typelessness makes some things really easy, but can confuse or complicate some other things.

Upvotes: 4

Related Questions