How to query by time in postgresql

Question

device_id	device_created_at
10e7983e-6a7b-443f-b0fe-d5e6485a502c	2022-08-10 20:55:16.695

i have a table where my date/time is of form: 2022-08-10 20:55:16.695 This is a timestampped object. I tried the following query but didn't return any rows:

select * from device where to_char(device_created_at,'YYYY-MM-DD HH24:MI:SS.FFF') = '2022-08-10 20:55:16.695'

The type of device_created_at is "timestamp without time zone"

How do i query based on timestamp in postgressql?

lemon · Accepted Answer · 2022-12-11 22:29:05Z

2

Try comparing timestamp values in place of strings:

SELECT * 
FROM device 
WHERE device_created_at = CAST('2022-08-10 20:55:16.695' AS TIMESTAMP)

Check the demo here.

answered Dec 11, 2022 at 22:29

lemon

15.6k6 gold badges23 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

How to query by time in postgresql

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