date_part???

How about just:

SELECT date_part('hour', test) from testing;

On Thu, Aug 29, 2002 at 05:30:31PM +0800, 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)

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

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.