In MYSQL I have two fields.

TIME field called status\_age. Format is HH:MM:SS
DATE TIME called create\_date. Format is YYYY-MM-DD HH:MM:SS

I want to ensure that when I subtract the TIME field from the DATETIME field that is will roll back to the previous day if necessary. I've tried timediff and date time diff but the formatting is incorrect. 

Any recommendations?

Thanks