Convert varchar data to time format in postgresql

Question

I currently have a range of transaction data, and I am trying to query the data for the sum of transactions within a certain time frame. One field, transaction_time is a varchar. An example of one of these times is "13:42", which corresponds to 1:42pm. I was experimenting around with to_timestamp, but I have been unable to figure it out. Would anyone have any idea as to how to alter this varchar to represent time data.

Kind regards

JustMe · Accepted Answer · 2017-11-16 07:40:34Z

1

Casting can be done two ways:

select cast('12:47' as time)

and

select '12:47'::time

answered Nov 16, 2017 at 7:40

JustMe

2,3833 gold badges25 silver badges46 bronze badges

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

Comments

Paul Maxwell · Accepted Answer · 2017-11-16 06:23:31Z

0

cast it to time.

select cast('13:42' as time)

answered Nov 16, 2017 at 6:23

Paul Maxwell

35.7k4 gold badges39 silver badges55 bronze badges

Collectives™ on Stack Overflow

Convert varchar data to time format in postgresql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related