Simplest explanation and example I could come up with to demonstrate why you should always use #Postgres' TIMESTAMP WITH TIME ZONE:
https://naildrivin5.com/blog/2024/10/10/a-simple-explanation-of-postgres-timestamp-with-time-zone.html
Dave Copeland :ruby: /
npub170…9esdj
2024-10-10 18:38:46
Author Public Key
npub170ujqrt6s9722d2z70cvswen4d9xn9hs7hnln8rh3q2wrt3c00qqc9esdjSeen on
wss://relay.momostr.pinkPublished at
2024-10-10 18:38:46Event JSON
{
"id": "c6cf6da80aa2c28e36355348b18215c5c9d5b7ceab31958d94b0474394996891",
"pubkey": "f3f9200d7a817ca53542f3f0c83b33ab4a6996f0f5e7f99c778814e1ae387bc0",
"created_at": 1728585526,
"kind": 1,
"tags": [
[
"t",
"postgres"
],
[
"proxy",
"https://ruby.social/@davetron5000/113284581043541128",
"web"
],
[
"proxy",
"https://ruby.social/users/davetron5000/statuses/113284581043541128",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://ruby.social/users/davetron5000/statuses/113284581043541128",
"pink.momostr"
],
[
"-"
]
],
"content": "Simplest explanation and example I could come up with to demonstrate why you should always use #Postgres' TIMESTAMP WITH TIME ZONE:\n\nhttps://naildrivin5.com/blog/2024/10/10/a-simple-explanation-of-postgres-timestamp-with-time-zone.html",
"sig": "31ba60715a59bb08128bb29e3865e7d70dc9d242322cce3543c29d0160acc84ee8a88015c6957e685321815bf2bb6558c0493e1423cbe4dadaa78f81747e9c0e"
}