How to collect date from separate time and date in postgres?

I

I

impressive172021-05-20 10:27:31

PostgreSQL

impressive17, 2021-05-20 10:27:31

How to collect date from separate time and date in postgres?

I have a time in the format 09:37:01.850000 (string) I
need to create a date where today's date and this time will
be
()) and time (as a string), so that the output is a date (or a date string) and I can insert it into the table

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

K

Kordamon2019-11-07 18:48:19

Dropbox: how to unsync for a subfolder? 3Reply

B

beginer1232016-08-23 17:21:03

Some database questions? 1Reply

O

Oleg Torbasov2016-08-24 12:45:42

Is it safe to share pg_catalog and information_schema schemas in PostgreSQL? 1Reply

K

kidar22016-08-25 06:54:56

How to get week number from american style date? 2Reply

W

wadomon2019-01-28 18:37:11

How to do ALTER TABLE for postgres pglogical? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question