CODEWITHSUNDEEP
mysql
BobDylan
BobDylan

Reputation: 15

mysql get current date and row date

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?

Upvotes: 0

Views: 7959

Answers (3)

BobDylan
BobDylan

Reputation: 15

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

seems working.

Thank you for all of your replies.

Upvotes: 0

Brendan Bullen
Brendan Bullen

Reputation: 11819

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 `

Upvotes: 1

Manjoor
Manjoor

Reputation: 4199

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

Upvotes: 0

Related Questions