How do I output the time in postgres sql

Question

I know about \echo but that just seems to output the rest of the line literally, i want something like \echo date

Please take a look to the documentation to learn differences between current_date and other function that gives also the current date/time --> here — Houari
– Houari, Commented Mar 13, 2015 at 11:22

Paul Taylor · Accepted Answer · 2015-03-13 09:29:47Z

1

So based on the comment

select current_time

works for me.

answered Mar 13, 2015 at 9:29

Paul Taylor

13.4k55 gold badges220 silver badges407 bronze badges

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

Comments

Alexi Theodore · Accepted Answer · 2020-09-30 02:01:29Z

0

The only example in pg docs is actually the answer to this...

\echo date

answered Sep 30, 2020 at 2:01

Alexi Theodore

1,84717 silver badges24 bronze badges

developer · Accepted Answer · 2023-11-15 14:09:26Z

0

And if you want both the date and the time (almost always) use:

select now();

answered Nov 15, 2023 at 14:09

developer

7277 silver badges17 bronze badges