[ 常見問題 ] How to compare dates in datetime fields in Postgresql?

Source From Here 
Question 
How to make below query right while the column update_date is of type as "date/time"? 

view plaincopy to clipboardprint?

1. select * from table where update_date >= '2013-05-03' AND update_date <= '2013-05-03'  

How-To 
One example as below: 

view plaincopy to clipboardprint?

1. SELECT *  
2. FROM table  
3. WHERE update_date >= '2013-05-03'::date  
4. AND update_date < ('2013-05-03'::date + '1 day'::interval);  

Supplement 
* PostgreSQL Doc - Date/Time Functions and Operators