From: Lucas Brasilino <brasilino@recife.pe.gov.br>
To: pgsql-sql@postgresql.org
Subject: Problem with timestamp field/time function.. (upgrading from 7.0 to 7.2.1)
Date: Tue, 20 Aug 2002 13:36:33 -0300
Message-ID: <3D627011.8000003@recife.pe.gov.br> (raw)
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
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
Subject: Re: Problem with timestamp field/time function.. (upgrading from 7.0 to 7.2.1)
In-Reply-To: <3D627011.8000003@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