0

I have a database with a table, jobs and i have written this query to get information from this table. But i am getting no results with this data and i have no idea why?

SELECT startDateTime, endDateTime FROM jobs WHERE startDateTime BETWEEN '19/11/2013' AND '20/11/2013'

Database Structure:

1 jobId int(11)
2 customerId int(11)
3 addressId int(11)
4 description text
5 startDateTime datetime
6 endDateTime datetime

Data:

1 | 1 | 1 | Light fitting | 2013-11-19 14:00:00 | 2013-11-19 16:00:0

Edited by Danny_3

2
Contributors
2
Replies
26
Views
4 Years
Discussion Span
Last Post by Danny_3
2

Try using Y-M-D format, see if that works?

SELECT startDateTime, endDateTime FROM jobs WHERE startDateTime BETWEEN '2013-11-19' AND '2013-11-20'
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.