Why am I getting iso 8601 dates from my Postgres database?

Question

I'm using Seekwell to connect my AWS postgres database to Sheets.

I think I'm converting my dates to standard 'date' (YYYY-MM-DD) format in the code, eg.

date(date_trunc('day', u.created_at::date)) Date_Created

However, when the query is run, my dates are iso 8601, eg.

2018-05-16T00:00:00.000Z

Of course, given that my results are going into Google Sheets, I can always convert those dates there in sheets, but that adds a layer of complexity that is hard to manage.

How can I make sure the dates are formatted correctly before the results land in sheets?

samthebrand · Accepted Answer · 2018-06-09 14:47:13Z

3

Michael from Seekwell tells me this is:

a bit of bug with how JDBC handles dates in the background. You're on Postgres, right? This should work from within the add-on:

to_char(your_date_column, 'YYYY-MM-DD')

Sheets will recognize that result as a date.

This worked.

answered Jun 9, 2018 at 14:47

samthebrand

3,1107 gold badges45 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tim Biegeleisen Over a year ago

I was going to ask you what Google Sheets expects. If it can accept a text date in the format you want, then you really want text, not date, output. What you wrote above is precisely that.

Collectives™ on Stack Overflow

Why am I getting iso 8601 dates from my Postgres database?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related