unix timestamp

From: Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: unix timestamp
Date: 2011-04-21 19:19:43
Message-ID: 93361C67E4EE844A80935863A4FF4B6C04E86CB9@Exch2010MB-2.univ.dir.wwu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Is there a way to query a unix timestamp date? In the database the orderdate field is a unix timestamp.
I would like to create the where clause to a query on a specific date like December 17, 2010.
Select * from orders where orderdate = '12/17/2010';

Thanks

Marc

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2011-04-21 19:59:07 Re: unix timestamp
Previous Message H S 2011-04-21 18:14:51 ./configure and libaudit