mysql get current date and row date

Question

Hi,

Is it possible to do sql query on what day is today and get the row of today for date column?

So let say today is july 25th, i have database table sales, column name date, date = sales transaction date in timestamp.

i need all row that the sales date is same with current date and also is it possible set value as gmt+5?

Answer 1

This will get you all the rows for today's date:

SELECT * FROM sales 
WHERE DATE(NOW()) = DATE(DATE_ADD(sales_transaction, INTERVAL 5 HOUR)) 
ORDER BY sales_transaction

As for GMT +5, Do you mean all rows with a sales date +5 hours or today +5 hours?

EDIT: Updated to add 5 hours to sales date. For a column called date, I would use the back-ticks to indicate it's a column name. e.g. SELECT `date`` FROM sales

I can't figure out how to work the back-ticks on the date field. But you should get the idea. Wrap your column names with `

Answer 2

Give some time and Check out Date Time Function of mySQL

  SELECT * FROM tablename WHERE salesdate = '1998-1-1';

If your date is stored in GMT timezone

Select *
FROM tablename
WHERE DATE_ADD(NOW(), INTERVAL 5 HOUR) = salesdate 

Answer 3

SELECT * FROM `sales` WHERE DAYOFMONTH(FROM_UNIXTIME(date)) = DAYOFMONTH(DATE(now()))

seems working.

Thank you for all of your replies.