Sorry, your browser does not support JavaScript!

Have an account?

Don't have account,

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

1+5 = ? ( 6 )

Have an account?

You must login to ask question.

Need An Account,

You must login to add post.

Need An Account,
Search
Ask A Question

LEARN, SHARE KNOWLEDGE & WORK TOGETHER

Aviance School is one of the largest web solutions platform in India for developers to learn and share​ ​their programming ​knowledge and build their careers.

Ask A Question
Home / Questions / Q 10510
Next
In Process
  • 0
Learner
Asked: In:

How to select record from last 6 months in a table using MySQL?

  • 0

I want to get the last 3-6 months’ records from  fund_master table. date_payment is the date type column.

MysqlPHP
Share

    1 Answer

    1. Professional
      This answer was edited.

      You can use DATE_SUB() to get the last 6 months’ records.

      select * from fund_master where date_payment BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL 180 DAY ) AND CURDATE( ) ;

      • 0

    Leave an answer