Get a Postgres timestamp value from postgres date and postgres time

Question

I have a postgres date and posgres time column. Is there any postgres function to get postgres timestamp from these columns. This timestamp value is used to compare with the Java sql timestamp object.

PostgreSQL supports string concatenation with CONCAT or with double pipeline (||).. double pipes does not work on date and time without casting but CONCAT does something like this sqlfiddle.com/#!17/340e0/123 should help you out — Raymond Nijland
– Raymond Nijland, Commented Aug 1, 2018 at 10:37
We need the CREATE TABLE statement for the database table. — Laurenz Albe
– Laurenz Albe, Commented Aug 1, 2018 at 10:49
It doesn't require any string concatenation, and it's right there in the beginning of the documentation, the + operator. A date value plus a time value will give you a timestamp value. Isn't that your purpose? — RealSkeptic
– RealSkeptic, Commented Aug 1, 2018 at 11:41

Filipe Mendes · Accepted Answer · 2020-10-29 06:20:23Z

1

You can just sum the two columns using + operator. When you sum a date with a time type, you'll get a timestamp as the answer.

Look at the first table's third line. https://www.postgresql.org/docs/current/functions-datetime.html

edited Oct 29, 2020 at 6:20

user330315

answered Oct 29, 2020 at 4:12

Filipe Mendes

1859 bronze badges

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

Collectives™ on Stack Overflow

Get a Postgres timestamp value from postgres date and postgres time

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related