Make the test work in any timezone

1 files changed, 9 insertions, 9 deletions

diff --git a/test/js/bun/sqlite/sql-raw.test.js b/test/js/bun/sqlite/sql-raw.test.js
index 9b6312dda..c571cbcc7 100644
--- a/test/js/bun/sqlite/sql-raw.test.js
+++ b/test/js/bun/sqlite/sql-raw.test.js
@@ -6,34 +6,34 @@ const dbPath = import.meta.dir + "/northwind.testdb";
 it("works", () => {
   const handle = SQL.open(dbPath);
 
-  const stmt = SQL.prepare(handle, 'SELECT * FROM "Orders" WHERE OrderDate > date($date)');
-  expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > date(NULL)`);
+  const stmt = SQL.prepare(handle, 'SELECT * FROM "Orders" WHERE OrderDate > datetime($date, "gmt")');
+  expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > datetime(NULL, "gmt")`);
 
   expect(
     Array.isArray(
       stmt.all({
         // do the conversion this way so that this test runs in multiple timezones
-        $date: new Date(new Date(1996, 8, 1, 0, 0, 0, 0).toUTCString()).toISOString(),
+        $date: "1996-09-01T07:00:00.000Z",
       }),
     ),
   ).toBe(true);
-  expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > date('1996-09-01T07:00:00.000Z')`);
+  expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > datetime('1996-09-01T07:00:00.000Z', "gmt")`);
 
   var ran = stmt.run({
-    $date: new Date(new Date(1997, 8, 1, 0, 0, 0, 0).toUTCString()).toISOString(),
+    $date: "1997-09-01T07:00:00.000Z",
   });
   expect(Array.isArray(ran)).toBe(false);
   expect(ran === undefined).toBe(true);
-  expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > date('1997-09-01T07:00:00.000Z')`);
+  expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > datetime('1997-09-01T07:00:00.000Z', "gmt")`);
 
   expect(
     Array.isArray(
       stmt.get({
-        $date: new Date(new Date(1998, 8, 1, 0, 0, 0, 0).toUTCString()).toISOString(),
+        $date: "1998-09-01T07:00:00.000Z",
       }),
     ),
   ).toBe(false);
-  expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > date('1998-09-01T07:00:00.000Z')`);
+  expect(stmt.toString()).toBe(`SELECT * FROM "Orders" WHERE OrderDate > datetime('1998-09-01T07:00:00.000Z', "gmt")`);
   expect(stmt.paramsCount).toBe(1);
   expect(stmt.columnsCount).toBe(14);
   expect(stmt.columns.length).toBe(14);
@@ -46,7 +46,7 @@ it("SQL.run works", () => {
   expect(typeof handle).toBe("number");
 
   expect(
-    SQL.run(handle, 'SELECT * FROM "Orders" WHERE OrderDate > date($date)', {
+    SQL.run(handle, 'SELECT * FROM "Orders" WHERE OrderDate > datetime($date, "gmt")', {
       $date: new Date(1996, 8, 1).toISOString(),
     }),
   ).toBe(undefined);