Forum Discussion

MrPatrick's avatar
MrPatrick
Icon for Helper I rankHelper I
4 years ago
Solved

Restricting data import by date - MySQL

I've got a database where all the tables go back to ~2013 but I'm only interested in the last 12 months. Currently I either import the whole lot and then filter it (which is incredibly slow and prone...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    MrPatrick 

    Why not make the start date dynamic on your query?  In T-SQL it would be.

     

    WHERE Event_Date >= DATEADD(MONTH,-12,CONVERT(DATE,GETDATE()))

     

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, MrPatrick ;

Please try it

select * from agent_log_backup where event_time >= (current_date - INTERVAL '12 months')

or

select * from agent_log_backup where event_time  BETWEEN DATE_SUB( CURRENT_DATE, INTERVAL 12 MONTH ) AND CURRENT_DATE

 Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.