在mysql中获取两个日期之间的记录 [英] To get records in between two date in mysql

问题描述

参见下表，
在此日期列类型中，varchar不是日期。

See the below table, In this date column type is varchar not date.

           |---------------------|
           |date       |   name  |
           |---------------------|
           |23-5-2005  | babi    |
           |20-6-2005  | ram     |
           |12-5-2005  | jhon    |
           |1-5-2004   | babi    |
           |23-5-2005  | guru    |

知道我想在两个日期之间获得记录。

Know I want to get records between two dates.

String gt = "12-5-2005";
String gt1 = "20-6-2005";
String query = ??;

如何编写查询以获取字符串gt和gt1之间的名称

How can I write the query to get names between strings gt and gt1

推荐答案

SQL部分应该如下所示。

The SQL portion should would work like below.

SELECT *
FROM 
    StackOverflow.`Table`
 WHERE STR_TO_DATE(`date`, '%d-%m-%Y') BETWEEN 
    STR_TO_DATE('12-5-2005', '%d-%m-%Y') AND STR_TO_DATE('20-6-2005', '%d-%m-%Y')

这篇关于在mysql中获取两个日期之间的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！