Home > mailing lists

select extract and subqueries - Mailing list pgsql-general

From	mike sears
Subject	select extract and subqueries
Date	November 21, 2001 00:52:24
Msg-id	001001c17234$fcadf7d0$fa00000a@wyd2002.org Whole thread Raw
List	pgsql-general

Tree view

I don't know if its possiable or not but I've been having problems trying to extract the timestamp out of one of my columns so that I can compare the dates.

if I do the following it gives me a proper epoch

en=# SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-11-20');
date_part
------------
1006232400
(1 row)

but if I try to use a subquery to get the date it gives me a parse error.

en=# SELECT EXTRACT (EPOCH FROM TIMESTAMP (select date from master));
ERROR: parser: parse error at or near "select"

is this simply just a limitation of the extract funtion or am I missing something?

Mike

pgsql-general by date:

From: Jason Earl
Date: 20 November 2001, 23:42:15
Subject: Re: migrating from MSSql

From: Thomas Lockhart
Date: 21 November 2001, 01:22:18
Subject: Re: select extract and subqueries

select extract and subqueries - Mailing list pgsql-general

Previous

Next