Answer the question
In order to leave comments, you need to log in
How to make select by timestamp column having date only?
Hello, please help me with a request.
Postgresql timestamp(2019-04-07 13:36:06.885) column.
How to find data for a specific date without hours and minutes, i.e. having only the date 2019-04-07;
Answer the question
In order to leave comments, you need to log in
select *
from the_table
where the_timestamp_column::date = date '2019-04-07'
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question