Thread: Time without seconds

Hello,

is it possible to get the time without the seconds and without the usage
of a formatting function?

Example:
CREATE TABLE test.testtime
(
  thetime time without time zone
);
INSERT INTO test.testtime (thetime) VALUES ('12:34:56');
INSERT INTO test.testtime (thetime) VALUES ('23:45');
SELECT thetime from test.testtime;
The result should be without the seconds.

I know that there are formatting functions for date/time. But I am
searching for a way to get a formatted time with a simple SQL query.

Thanks
Andreas

On Tue, Dec 2, 2008 at 10:37 AM, Andreas Kraftl
<andreas.kraftl@kraftl.at> wrote:
>
> Hello,
>
> is it possible to get the time without the seconds and without the usage
>
> of a formatting function?

regexp and/or date_trunc


--
GJ