Check for duplicate record in postgresql

Question

I have one table in postgresql and my table contain one column of timestamp without timezone

i want to write one query which will check if same date inserted multiple times or not if same date present more than once query should return that date

like 12 Sep 2011,12 Sep 2011,12 Sep 2011,10 Sep 2011,

Here 12 Sep 2011 date is present more than once how to write query for that

Bruce · Accepted Answer · 2011-09-16 11:36:56Z

9

SELECT my_date FROM my_table GROUP BY my_date HAVING COUNT(my_date) > 1

edited Sep 16, 2011 at 11:36

Bruce

1,53813 silver badges17 bronze badges

answered Sep 16, 2011 at 7:11

reader_1000

2,51118 silver badges15 bronze badges

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

Comments

Marco Mariani · Accepted Answer · 2011-09-16 11:41:23Z

1

If you have timestamps, you should drop the 'time' part:

SELECT time_column::DATE FROM my_table GROUP BY time_column::DATE HAVING COUNT(*) > 1

answered Sep 16, 2011 at 11:41

Marco Mariani

13.8k7 gold badges42 silver badges55 bronze badges

Collectives™ on Stack Overflow

Check for duplicate record 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