Message-ID: <3D627011.8000003@recife.pe.gov.br>
Date: Tue, 20 Aug 2002 13:36:33 -0300
From: Lucas Brasilino <brasilino@recife.pe.gov.br>
Organization: Emprel - Empresa Municipal de Informatica
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:0.9.4) Gecko/20011126 Netscape6/6.2.1
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Problem with timestamp field/time function.. (upgrading from 7.0 to
	7.2.1)
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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"
        Column       |           Type           | Modifiers
--------------------+--------------------------+-----------

materiadata        | timestamp with time zone | not null
mmateriatitulo      | character varying(80)    | not null
materiasequencial  | numeric(30,6)            | not null


I used to execute this query:

	select max(time(materiadata)) from materia;

or
	select materiasequencial, materiatitulo, time(materiadata)
	from materia
	order by time(materiadata) desc;	

	I've read at PostgreSQL 7.3dev Administrator Guide's Release Notes that 
time() and timestamp() functions in postgresql 7.2 are deprecated (so in 
7.2.1).

	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!


Thanks a lot in advance.
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