MySQL date format is not supported

Question

When we call this procedure

Call get_reports_by_time('2014-12-22 11:19:26 AM').

no data is returned

but when we call this

Call get_reports_by_time('2014-12-22 11:19:26 ')

all the records for that day is returned. why its so?

get_reports_by_time is a function you (or your company) created, so it is relying on a format since you're probably not using timestamps.So we need to see your procedure to be able to help you — Jeredepp
– Jeredepp, Commented Dec 22, 2014 at 11:43

road242 · Accepted Answer · 2014-12-22 11:49:24Z

1

string representation of dates/timestamps,... is dependent on your db settings.

In your case one representation can be converted to a date (assuming that you work with a date type in your stored procedure) and one representation cannot be converted to a date.

I higly suggest to use date and time types and not any string representation for your paremeters (if you need a string representation then convert it by YOURSELF using date/str_to_date)

answered Dec 22, 2014 at 11:49

road242

2,5321 gold badge22 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

MySQL date format is not supported

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related