Ahh it says something like
```
{"hint":null,"detai...
# helpy
YogurtDrinker
07/30/2021, 2:14 AMAhh it says something like
Copy code
{
"hint": null,
"details": null,
"code": "22023",
"message": "time zone \"gmt+0800\" not recognized"
}e
everconfusedguy
07/30/2021, 2:15 AMCan you try new Date().toISOString() @User ?
y
YogurtDrinker
07/30/2021, 2:18 AMOh wow that seemed to work
YogurtDrinker
07/30/2021, 2:18 AMThanks!
YogurtDrinker
07/30/2021, 2:18 AMSo in general i should convert it to ISO?
s
Scott P
07/30/2021, 2:30 AMnew Date() gives a 'human friendly' verbose date. new Date().toISOString() gives a timestamp for the local timezone (i.e. the timezone of the computer/server it's running on)
For example
y
YogurtDrinker
07/30/2021, 2:55 AMAhh i see nice thanks all
YogurtDrinker
07/30/2021, 2:56 AMGenerally if i want to store datetime in database is there a best practice?
YogurtDrinker
07/30/2021, 2:56 AMLike so it works cross region
s
soedirgo
07/30/2021, 3:29 AMOne would be to use timestamptz instead of timestamp: https://stackoverflow.com/a/22925669
y
YogurtDrinker
07/30/2021, 3:30 AMI see. I'll look and keep it in mind. Thanks!