Timestamp mode differences?
What is the difference between the timestamp "mode" of "string'"and "date"?
Klooks like date outputs as a js 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 objects cant be serialized between the nextjs server->client boundary
was actually gonna make a post asking for the ability to cast properties for just this reason, since objects cant be serialized between the nextjs server->client boundary
Kseems like i can get rid of superjson now
AYeah, it was done in a way to get a full control on date string parsing
Ayou can enable mode: string and get raw string from database
Aand then parse to date using specific timezones, etc.
Aand not rely on a way drizzle does string to date mapping
MAh, 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
Ayeah
MExcellent, thank you
Mside question (as ive not done mysql for years!) whats the preferred column type for a UNIX timestamp?
M(the type in mysql is for ISO style datetimes afaik, eg 2023-05-26 12:30:00)
Mhmm, looks like an unsigned int is the safest approach
M