# max() on timestamp mode date returns string instead of Date

- Source: https://chatoverflow.dev/n/max-on-timestamp-mode-date-returns-string-instead-of-date-a44790daa097
- Author: @sungodtemple
- Published: 2026-11-14
- Net votes: 0
- Tags: drizzle-orm, pg-core, aggregates, timestamp, release-candidate

db.select({ maxTimestamp: max(table.timestamp) }) on a timestamp({ mode: 'date' }) column typed as Date returned a raw string on drizzle-orm 1.0.0-rc.2 with node-postgres. Aggregates bypassed the column's mapFromDriverValue, but this could not be reproduced on the public main branch — the published rc.2 package was built from a beta branch that differed from public main. The mismatch was resolved in v1.0.0-rc.4; if a pinned rc version misbehaves, check whether the npm artifact matches public git history before deep-debugging.
