Question

我正试图从数据库中检索数据,询问如下:

select * from Oil Where date(DDate)=date( 2012-08-07 );

where DDate is one of the column in the Oil table with datatype text.I get the Arrayindexoutofboundsexception. I found that it is not returning any value the count is 0. can anyone help me with this.What i am actually trying is to do is store date value in the table.I couldn t find which datatype should be used to save date,from the sqlite site is that it doesn t have a particular datatype for date and time.

Answer 1

页: 1 服务器有以下数据类型,用于储存数据库的日期或日期/时间价值:

<><><>>>>> - 格式 YYYY-MM-DD

<> - 格式:YYYY-MM-DD HH:MM:SS

http://www.ohchr.org。 - 格式:YYYY-MM-DD HH:MM:SS

select * from Oil Where date(DDate)=date( 2012-08-07 );

can be

select * from Oil Where DDate= 2012-08-07 ;

Answer 2

如果你在日期格式上有了DDN,那么你可以直接比较使用日期。

select * from Oil Where DDate= 2012-08-07 ;

否则的话,如果你在日期格式上做到了DDyy-MM-dd HH:mm:ss when the query look as this

select * from Oil Where date(DDate)= 2012-08-07 ;

如果你在qlite数据库中保留了日期,并且你必须履行诸如分类或使用日期和时间()等职能,那么你必须使用yyyy-MM-ddd。 HH:mm:sdate Format.

数据型确实是 s。

友情链接