selecting the rows from db based on date

Question

I have a list of row's in mysql tables

+--------+-----+------------+------------+------------+-----------+
| off_id | uid | leave_from | leave_to   | leave_code | reason    |
+--------+-----+------------+------------+------------+-----------+
|      1 |   1 | 2012-01-01 | 2012-01-05 | OFF        | asdsda    |
|      2 |   1 | 2012-01-15 | 2012-01-16 | OFF        | asdd      |
|      5 |   1 | 2012-02-03 | 2012-02-05 | OFF        | gfjghjhgj |
+--------+-----+------------+------------+------------+-----------+

I have to select the rows that are in between the date 2012-01-01 to 2012-01-05. How can i do this please help.

Clive · Accepted Answer · 2012-01-06 18:16:36Z

3

SELECT * 
FROM tbl
WHERE leave_from >= '2012-01-01'
AND leave_to <= '2012-01-05'

answered Jan 6, 2012 at 18:16

Clive

1

Sign up to request clarification or add additional context in comments.

Comments

Clive · Accepted Answer · 2012-01-06 18:18:01Z

2

select * from table where leave_from between '2012-01-01' and '2012-01-05'

edited Jan 6, 2012 at 18:18

Clive

1

answered Jan 6, 2012 at 18:17

Rajat Singhal

11.3k5 gold badges40 silver badges57 bronze badges

Comments

Shyju · Accepted Answer · 2012-01-06 18:15:38Z

1

SELECT Off_Id,uid,Leave_from,leave_to,leave_code
FROM YourTableName
WHERE Leave_From>="2012-01-01" and Leave_to <="2012-01-05"

answered Jan 6, 2012 at 18:15

Shyju

220k106 gold badges421 silver badges499 bronze badges

Comments

SlavaNov · Accepted Answer · 2012-01-06 18:16:26Z

1

If I understand your question right:

SELECT * FROM `table_name` 
WHERE leave_from >= "2012-01-01" AND leave_to <= "2012-01-05"

answered Jan 6, 2012 at 18:16

SlavaNov

2,4851 gold badge19 silver badges26 bronze badges

Comments

Vijeenrosh P.W · Accepted Answer · 2012-01-06 18:21:55Z

0

point 1 : you could use > < <= >= with date datatypes .

the above can be achieved by

SELECT * FROM table WHERE leave_from > '2012-01-01' AND leave_from <'2012-01-05';

answered Jan 6, 2012 at 18:21

Vijeenrosh P.W

3691 gold badge3 silver badges8 bronze badges

Collectives™ on Stack Overflow

selecting the rows from db based on date

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related