From: Lucas Brasilino <brasilino@recife.pe.gov.br>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problem with timestamp field/time function.. (upgrading
Date: Thu, 22 Aug 2002 08:46:07 -0300
Message-ID: <3D64CEFF.1090609@recife.pe.gov.br> (raw)
References: <20020820100127.S43175-100000@megazone23.bigpanda.com>
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 could probably use CAST(materiadata as time) I'd guess.
> I believe that at this point you can still use the functions, you just
> need to double quote them ("time"(materiadata)) to differentiate them
> from the type specifiers.
>
Well, it seems to work only with "timestamp without time zone" type. But
worked. Thanks a lot.
For me it's a new approching not using functions such as time, but
"casting" it to a "time" type ( like <sql>select materiadata::time from
materia;</sql>).
If PostgreSQL development group change it's point of view, I suppose
there's some advantage. Do you know some advantages ??
bests regards
--
[]'s
Lucas Brasilino
brasilino@recife.pe.gov.br
http://www.recife.pe.gov.br
Emprel - Empresa Municipal de Informatica (pt_BR)
Municipal Computing Enterprise (en_US)
Recife - Pernambuco - Brasil
Fone: +55-81-34167078
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: brasilino@recife.pe.gov.br, sszabo@megazone23.bigpanda.com
Subject: Re: Problem with timestamp field/time function.. (upgrading
In-Reply-To: <3D64CEFF.1090609@recife.pe.gov.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox