Postgresql combining date, time and microseconds into timestamp

Question

I have a table with the following fields:

my_date     my_time     my_time2
2017-04-14  10:00:01    286115

How do I combine these fields into timestamp column like 2017-04-14 10:00:01.286115? Unfortunately select my_date+my_time+my_time2 from my_table works fine only for the first two fields. Thanks in advance.

What are the data types?

Clodoaldo Neto
– Clodoaldo Neto

2017-04-15 10:44:58 +00:00
Commented Apr 15, 2017 at 10:44 — Clodoaldo Neto
– Clodoaldo Neto, Commented Apr 15, 2017 at 10:44
date,time,int4 respectively.

dmitry
– dmitry

2017-04-15 12:01:50 +00:00
Commented Apr 15, 2017 at 12:01 — dmitry
– dmitry, Commented Apr 15, 2017 at 12:01

Pavel Stehule · Accepted Answer · 2017-04-15 12:54:57Z

1

select date '2017-04-14' + time '10:00:01' + 286115 * interval '1usec';
┌────────────────────────────┐
│          ?column?          │
╞════════════════════════════╡
│ 2017-04-14 10:00:01.286115 │
└────────────────────────────┘
(1 row)

answered Apr 15, 2017 at 12:54

Pavel Stehule

46.6k6 gold badges103 silver badges102 bronze badges

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

Collectives™ on Stack Overflow

Postgresql combining date, time and microseconds into timestamp

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