On 04/21/2011 12:19 PM, Marc Fromm wrote:
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
If by "unix timestamp" you mean epoch, just extract the epoch from your date or timestamp:
steve=# select extract(epoch from date '12/17/2010');
date_part
------------
1292572800
Cheers,
Steve