| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | jerome <jerome(at)gmanmi(dot)tv> |
| Cc: | PostgresGeneral <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: date_part??? |
| Date: | 2002-08-29 13:59:08 |
| Message-ID: | 20020829065730.K96596-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 29 Aug 2002, jerome wrote:
> 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)
TIMESTAMP '...' is for timestamp literals. timestamp(test) isn't a
literal. You probably just want test.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-08-29 14:01:36 | Re: rules and functions as arguments |
| Previous Message | Stephan Szabo | 2002-08-29 13:57:09 | Re: Deleting foreign key constraints |