Fix DateTime conversion

MCMatters · Nov 13, 2023 · f9fbb86 · f9fbb86
1 parent f02c910
commit f9fbb86
Showing 1 changed file with 11 additions and 0 deletions.
diff --git a/src/Helpers/DbHelper.php b/src/Helpers/DbHelper.php
@@ -4,6 +4,7 @@
 
 namespace McMatters\Helpers\Helpers;
 
+use DateTime;
 use Illuminate\Container\Container;
 use Illuminate\Support\Arr;
 use Stringable;
@@ -186,6 +187,16 @@ protected static function transformSqlBinding(mixed $binding): float|int|string
                 return '';
 
             case 'object':
+                if (method_exists($binding, '__toString')) {
+                    return self::escapeString((string) $binding);
+                }
+
+                if ($binding instanceof DateTime) {
+                    return $binding->format('Y-m-d H:i:s');
+                }
+
+                return '';
+
             case 'string':
             default:
                 return self::escapeString((string) $binding);