Re: [SQL] Problem with timestamp field/time function.. (upgrading

2002-08-22 Thread Stephan Szabo
On Thu, 22 Aug 2002, Lucas Brasilino wrote: > Hi Stephan > > >>So, how can I get the same result above without using time() ?? > >>Or if it not possible, how can I extract (yes, I tried with extract() > >>function too) time from a timestamp column? > >>I know it's quite simple question..

Re: [SQL] Problem with timestamp field/time function.. (upgrading

2002-08-22 Thread Lucas Brasilino
Hi Stephan >> So, how can I get the same result above without using time() ?? >>Or if it not possible, how can I extract (yes, I tried with extract() >>function too) time from a timestamp column? >> I know it's quite simple question... but I haven't find any clue! >> > > In general you

Re: [SQL] Problem with timestamp field/time function.. (upgrading

2002-08-20 Thread Stephan Szabo
On Tue, 20 Aug 2002, Lucas Brasilino wrote: > I'm running postgresql 7.0 with a column like: > > Table "materia" > Column | Type | Modifiers > +--+--- > > materiadata| timesta

[SQL] Problem with timestamp field/time function.. (upgrading from 7.0 to 7.2.1)

2002-08-20 Thread Lucas Brasilino
Hi All: I've googling around, searching the mailinglist archive and reading FAQ's but I haven't find the answer for my question. And I know it is quite commom! I'm trying upgrading to 7.2.1. I'm running postgresql 7.0 with a column like: Table "materia"