Record🤔

uri:

"at://did:plc:iwpxnj7rzdynjkkr7rxaa5is/app.bsky.feed.post/3lbzadgpxrl2n"

cid:

"bafyreihmdnvt5nhtuwlky32x2ylhmoe5mpi65gndyzvum2w43zn34aktn4"

value:

text:

"Postgres stores `TIMESTAMP WITH TIME ZONE` columns converted to UTC, and it does not preserve timezone information.

This can lead to nasty bugs!"

$type:

"app.bsky.feed.post"

embed:

$type:

"app.bsky.embed.images"

images:

• alt:

  "For timestamp with time zone, the internally stored value is always in UTC (Universal Coordinated Time, traditionally known as Greenwich Mean Time, GMT). An input value that has an explicit time zone specified is converted to UTC using the appropriate offset for that time zone. If no time zone is stated in the input string, then it is assumed to be in the time zone indicated by the system's TimeZone parameter, and is converted to UTC using the offset for the timezone zone."

  image:

  

  View blob content

  $type:

  "blob"

  ref:

  $link:

  bafkreigtljqq2yy66mgpfpmgmp4mfacmm5wzzqwvnbziv5ughf4kfcr354

  mimeType:

  "image/png"

  size:

  122182

langs:

createdAt:

"2024-11-28T14:05:23.000Z"