K
Kysely•4mo ago
djMax

Is there a way to keep full date precision?

It appears that selecting dates from Postgresql loses some precision, which wreaks havoc with my paging logic. Is there a way to get dates to have full precision on the JS side?
1 Reply
koskimas
koskimas•4mo ago
You can't increase the accuracy of a JavaScript Date, but you can install a custom date parser that creates an ISO date string with full precision https://kysely.dev/docs/recipes/data-types
Data types | Kysely
When talking about data types in Kysely we need to make a distinction between the two kinds of types:
Want results from more Discord servers?
Add your server
More Posts
How can I get total row count without blowing up types?I have a simple query function that is in charge of generating a list of ids so that it can be passeIs there a way to handle migrations with .sql files?I enjoy being able to control the specific queries in the migration files. To do this, I use postgraPostgres: Transaction not honouring previous queriesHi, I have a table with unique constraint on some columns. In a transaction, I am deleting all the How do I specify a MySQL index hint?Hi, I am trying to build the following query (as a CTE, as part of a larger query), but I can not woquestion about transaction isolation levelI am not sure if the way I do queries with transaction with kysely is the right way. I would be gladcase when column = another columnI have a semi-complex query, and I'm trying to use a case() that includes a when() where the two val