PostgreSQL local time

Question

Is there a better way to get local time to the second in PostgreSQL than this?

Set timezone= 'America/New_York';
Select to_char(current_timestamp, 'MM/DD/YYYY HH24:MI:SS') As EasternCurrentTime;

We do a lot of these in different places for logging within our ETL and would like to do it on one line.

You could abstract it into a postgres function so at least its just a one-liner and compartmentalized to the current thread/query — Cody Caughlan
– Cody Caughlan, Commented Sep 28, 2018 at 16:30

Laurenz Albe · Accepted Answer · 2018-09-28 17:06:58Z

1

I'd suggest

SELECT to_char(current_timestamp AT TIME ZONE 'America/New_York',
               'MM/DD/YYYY HH24:MI:SS');

answered Sep 28, 2018 at 17:06

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

2 Comments

Thanks a lot for that (though I think we're not supposed to post these)

Nobody will complain as long as you don't write it as an answer. The preferred way to express thanks is upvoting and/or accepting the answer.