Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

is there an easy way to convert `timestampz` to just date / time / zone? I have tried `.toLocaleString` but it doesn't seem to work

Hello <@370461203555811328>!
This thread has been automatically created from your message in <#843999948717555735> a few seconds ago.

We have already mentioned the <@&951828363943759883> so that they can see your message and help you as soon as possible!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates.

**Want to change the title?**
Use the ``/title`` command!

**We have solved your problem?**
Click the button below to archive it.

🆕 converting timestampz to human readable

timestampz does NOT actually store any timezone info - the timestamp is still stored in GMT but the modifier instructs the DB to make any necessary conversion BEFORE storing the date. For example, try this in your preferred DB console:
```
select '1999-01-08 04:05:06 -8:00'::timestamp with time zone;
```

you can extract the date by casting the timestamp to a date like this:
```
select now()::date;
```

Similarly you can extract the time by casting to time:
```
select now()::time;
```

how could i do that within React? I am just displaying the table info like so ```<td className="px-4 py-2">{log.created_at}</td>```

so just using `.select('*')` when pulling it

oh - when you said timestampz I thought you were talking about SQL or PLpgSQL

I don't think there is timestampz in JavaScript - you only have the Date type - is that what you are talking about?

yeah i just need to convert `2022-05-18T14:03:45.78706+00:00` to a readable format

if you are fetching a timestampz column from the db via Supabase REST call, I think that gets converted to a string in JSON, so you need to construct a Date object from that string

and then you can extract all the parts using the Date object

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date

for example: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/getFullYear