search

benjamin658 / typeorm-cursor-pagination

Cursor-based pagination works with TypeORM Query Builder.
MIT License
186 stars 40 forks source link

invalid input syntax for type timestamp: \"Sat Jan 01 2000 00:59:53 GMT+0100 (West Africa Standard Time)\" #78

Closed shellking4 closed 1 year ago

shellking4 commented 1 year ago

Hello. Thanks for the work on this package. I get this error when using createdAt as paginationKey. I guess it has to do with the format of the date but How can I solve it ?

benjamin658 commented 1 year ago

It seems this error is returned by PostgreSQL; please check that the timestamp format is valid.

shellking4 commented 1 year ago

It seems this error is returned by PostgreSQL; please check that the timestamp format is valid.

Thank you for your reply. It's solved now. I'm going to close this issue by the way

iamsr commented 1 year ago

what's the solution for mysql? I have column like this - @CreateDateColumn() createdAt: string;

the date format in pagination query for cursor is causing issue. I