How can I perform a distinct when the system displays millisecond in my timestamps? I just need the date.
My query is like this:
select distinct orders.client_po, orders.order_code, orders.created_at, carts.checkout_at from orders left outer join carts on carts.code = orders.cart_id
carts.checkout_at is the same for all my orders but
orders.created_at can be different. Some orders can be created the next day, the next minute and I want to know that but when they are created during the same second I get too much duplicate information.
Format of my dates is timestamp without time zone.