why query between dates returns empty

Question

I'm using the following query:

$sql = "SELECT regTime FROM customers WHERE 'regTime' BETWEEN '2016-04-14 00:00:00' AND '2016-04-16 23:59:59'";

and the result i get is empty array.

what can be the solution ? and why it's happening ? Thanks.

Mark Baker · Accepted Answer · 2016-04-06 08:57:20Z

3

WHERE 'regTime'

If you have to quote column names, use backticks (`).... simple single quotes (') indicate a string literal.... so you're trying to check if the string 'regdate' is between dates, not the column value

answered Apr 6, 2016 at 8:57

Mark Baker

213k34 gold badges354 silver badges391 bronze badges

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

2 Comments

sagi Over a year ago

"If you have to quote" , you should include an explanation when he have to use quote them.

nim Over a year ago

to change it also in the dates ? i changed it everywhere still returns empty

krunal modi · Accepted Answer · 2016-04-06 09:24:57Z

0

SELECT [originalAlarmTime] FROM [dbo].[Alarms] WHERE originalAlarmTime BETWEEN '2015-07-01 20:18:58.000' AND '2015-07-01 20:20:47.000'

SELECT [originalAlarmTime] FROM [dbo].[Alarms] WHERE originalAlarmTime >= '2015-07-01 20:18:58.000' AND originalAlarmTime <= '2015-07-01 20:20:47.000'

answered Apr 6, 2016 at 9:24

krunal modi

13510 bronze badges

Collectives™ on Stack Overflow

why query between dates returns empty

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related