Timestamp mode differences?
What is the difference between the timestamp "mode" of "string'"and "date"?
5 Replies
looks like date outputs as a js
Date object, string outputs it as a string
was actually gonna make a post asking for the ability to cast properties for just this reason, since Date objects cant be serialized between the nextjs server->client boundary
seems like i can get rid of superjson nowYeah, it was done in a way to get a full control on date string parsing
you can enable mode: string and get raw string from database
and then parse to date using specific timezones, etc.
and not rely on a way drizzle does string to date mapping
Ah, so its just for how the data is marshalled from the database? Gotya. I thought it had something to do with the creation of the column in MySQL
yeah
Excellent, thank you
side question (as ive not done mysql for years!) whats the preferred column type for a UNIX timestamp?
(the
timestamp type in mysql is for ISO style datetimes afaik, eg 2023-05-26 12:30:00)
hmm, looks like an unsigned int is the safest approach
š