Standardize return format of dates and datetimes for SQL

Question

Standardize return format of dates and datetimes for SQL

chewselene opened this issue 5 years ago · 1 comments

We are not guaranteed that datetimes/dates will always be returned in the expected format of GraphQLDate/GraphQLDateTime. We can add CONVERTs to the SQL queries to ensure that the dates and datetimes are always formatted the same way.

https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/

Answer 1 · 2020-01-10T20:45:21.000Z

Maybe we can make the requirement that the used DB-API, e.g. pydobc, has to return a python datetime object. This requirement is consistent with the python DB-API implementation hints https://www.python.org/dev/peps/pep-0249/#implementation-hints-for-module-authors and all of the DB-APIs that I've seen follow this standard.