如何从dd-mm-yyyy格式的sqlite db中选择两个日期之间的数据？ [英] How to select data between two dates from sqlite db in dd-mm-yyyy format?

问题描述

我在 dd-mm-yyyy 格式的资料库中有日期栏。

两个日期之间的数据。

我尝试了

  SELECT * FROM t_data where '01 -05-2012 00:00:00'and '31 -05-2012 23:59:59'
  

和

  SELECT * FROM t_data where orderdate> = '05 -05-2012'and orderdate< ='31-05-2012'
  

如何解决此问题？

解决方案

使用：

  select * from tbl_name其中Attribute_name在'yyyy-mm-dd'和'yyyy-mm-dd'之间; 
  

这里Attribute_name是 date_time p>

例如：

  select * from tbl_node where mydate' -02'和'2014-02-06'; 
 
 1 | 1 | 123 | 456 | 12eb-ab | 1 | 1 | 254 | 123 | 19 | 2014-02-03 16:00:44 
 2 | 1 | 123 | 456 | 12eb-ab | 1 | 1 | 254 | 123 | 19 | 2014-02-03 16:01:03 
 3 | 1 | 123 | 456 | 12eb-ab | 1 | 1 | 19 | 2014-02-03 16:00:57 
  

i have date column in my database in dd-mm-yyyy format.

i want to search the data between two dates.

i tried

SELECT * FROM t_data where orderdate between '01-05-2012 00:00:00' and '31-05-2012 23:59:59'

and

SELECT * FROM t_data where orderdate >= '05-05-2012' and  orderdate <='31-05-2012'

How to resolve this issue?

解决方案

use :

select * from tbl_name where Attribute_name between 'yyyy-mm-dd' and 'yyyy-mm-dd';

here Attribute_name is date_time column name

example :

select * from tbl_node where mydate between '2014-02-02' and '2014-02-06';

1|1|123|456|12eb-ab|1|1|254|123|19|2014-02-03 16:00:44
2|1|123|456|12eb-ab|1|1|254|123|19|2014-02-03 16:01:03
3|1|123|456|12eb-ab|1|1|254|123|19|2014-02-03 16:00:57

这篇关于如何从dd-mm-yyyy格式的sqlite db中选择两个日期之间的数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！