Обсуждение: date_part???
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)
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/ > There are 10 kinds of people in the world, those that can do binary > arithmetic and those that can't.
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.