| From: | "mike sears" <matrix(at)quadrent(dot)net> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | select extract and subqueries |
| Date: | 2001-11-21 02:12:31 |
| Message-ID: | 001f01c17233$6e0d0490$fa00000a@wyd2002.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mike sears | 2001-11-21 02:34:02 | select extract and subqueries |
| Previous Message | Jason Earl | 2001-11-21 01:34:56 | Re: migrating from MSSql |