Welcome Guest, Not a member yet? Register   Sign In
Solved: SELECT * WHERE timestamp = DATE
#1

[eluser]Jan_1[/eluser]
Sorry, stupid question, but I don't get it.

I have a timestamp in my MySQL table (2012-03-14 20:05:12)
I want all entries on a special date which I pick with JQuery datepicker (2012-03-14)
If I use ->where() or ->like() there is no result.
If I put in 2012-03-14 20:05:12 as text - I get the result. So it's about the time?

Excuse me, but, what's the right way to do it?
#2

[eluser]Jan_1[/eluser]
restarted my computer. any problems.
man...




Theme © iAndrew 2016 - Forum software by © MyBB