Delete Elequent records older than 60 minutes

Question

How can I delete all Eloquent Records in a database where the created_at or updated_at field is older than 60 minutes? (or any amount of time for the example)

edit: posted solution as answer as @Alexxus suggested

Answer 1

Laravel have a build in Carbon date class which handles all the timezone problems for you.

Example:

$date  = Carbon::now()->subMinutes( 60 );
MyModel::where( 'updated_at', '<=', $date )->delete();

Answer 2

Solved -> With ceejayoz his link

• Make a date object and minus the amount of time.
• Covert the date object to string to match Eloquent formatting
• Compare formatted string against updated_at

I'm using the following code:

$date = new DateTime;
$date->modify('-60 minutes');
$formatted = $date->format('Y-m-d H:i:s');
MyModel::where('updated_at', '<=', $formatted)->delete();

Thanks ceejayoz!