MySQL Forums
Forum List  »  Newbie

Date equality query
Posted by: Ags Karan
Date: May 17, 2016 10:44AM

Hi All ,

I want to select a particular date from the table and If I do like below it wont retrieve me any rows .

select * from table_name where customer_id ="78788" and timestamp = "2016-05-13";


but if i do it like this


select * from table_name where customer_id ="78788" and timestamp >= "2016-05-13"; then I am getting but all the things that are greater than this date also retrieved , I just want to get perticular dated rows .

Please help me to get this .

Options: ReplyQuote


Subject
Written By
Posted
Date equality query
May 17, 2016 10:44AM
May 17, 2016 11:20AM
May 23, 2016 03:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.