MySQL phpMyAdmin error in a simple date query

Question

In MySQL using phpMyAdmin I am trying out this simple query to fetch rows that satisfy a certain date criteria:

select * 
from student_invoice
where date_generated < '2012-01-01'

The date_generated is of date type. I get an error in phpMyAdmin that says:

ERROR: Unclosed quote @ 64 STR: '

I have closed all quotes so its not making sense. The phpMyAdmin version is 2.11.9.6

Clearly, this isn't your real query. I can tell by the fake sounding table and column names. I have a feeling there is something else going on that we're not seeing. Can you paste your real query? — Asaph
– Asaph, Commented Nov 8, 2012 at 0:50
I am doing this frm phpMyAdmin and would like to have it working from here. — dr_rk
– dr_rk, Commented Nov 8, 2012 at 0:55

Gsinti · Accepted Answer · 2012-11-08 01:13:22Z

2

Adding a new answer, as it's unrelated to my other one.

According to this bugzilla post here, your version suffers from this bug!

Upgrading to 2.11.11 or higher should fix this issue.

answered Nov 8, 2012 at 1:13

Gsinti

1248 bronze badges

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

Comments

Gsinti · Accepted Answer · 2012-11-08 00:53:11Z

1

This may sound silly, but have you tried wrapping the date in double quotes?

SELECT * 
FROM sometable
WHERE somedatecolumn < "2012-01-01"

answered Nov 8, 2012 at 0:53

Gsinti

1248 bronze badges

5 Comments

dr_rk Over a year ago

Yup this was the first thing I tried. I get ERROR: Unclosed quote @ 64 STR: "

Gsinti Over a year ago

Very strange. Is this a recent issue? Have you done date range checks successfully in the past? You might want to try updating your phpMyAdmin installation if possible.

dr_rk Over a year ago

I must have at some point surely, but as I normally code in C++ I come back to php for web stuff occasionally. It is weird that this isnt working

Gsinti Over a year ago

What version of phpMyAdmin are you currently running?

dr_rk Over a year ago

I have put the version in my question. For some reason the version wont appear here in the comment,

Asaph · Accepted Answer · 2012-11-08 00:45:54Z

0

Make sure that those are actually single quotes surrounding the date, not backticks.

answered Nov 8, 2012 at 0:45

Asaph

164k25 gold badges204 silver badges204 bronze badges

1 Comment

dr_rk Over a year ago

I checked that. It is all single quotes

eatonphil · Accepted Answer · 2012-11-08 00:46:29Z

0

Not familiar with the specific error. But you could try casting your static date to a date format, just to make sure it jives with the datecolumn format. Or even casting both? I.e:

  where cast(somedatecolumn as DATE) < cast('2012-01-01' as DATE)

I have a feeling that won't work though. So maybe this?:

  where somedatecolumn < cast('2012-01-01' as DATE)

answered Nov 8, 2012 at 0:46

eatonphil

13.9k30 gold badges81 silver badges141 bronze badges

1 Comment

Asaph Over a year ago

Nah. That's not necessary in MySQL. This isn't his problem.

Collectives™ on Stack Overflow

MySQL phpMyAdmin error in a simple date query

4 Answers 4

Comments

5 Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

5 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related