date_part???

From: jerome <jerome(at)gmanmi(dot)tv>
To: PostgresGeneral <pgsql-general(at)postgresql(dot)org>
Subject: date_part???
Date: 2002-08-29 09:30:31
Message-ID: 200208290911.g7T9BJU45264@gmanewmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i have a table
Attribute | Type | Modifier
-----------+-----------+----------
test | timestamp |

SELECT date_part('hour', TIMESTAMP 'timestamp(test)') from testing;
ERROR: Bad timestamp external representation 'timestamp(test)'

** this one gives me an error but the DOCU says:
-- date_part(text, timestamp)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Dalitz 2002-08-29 09:51:32 Re: Deleting foreign key constraints
Previous Message Mark Kirkwood 2002-08-29 09:26:56 Re: Free space mapping (was Re: Multi-Versions and Vacuum)