On Tue, Dec 2, 2008 at 10:37 AM, Andreas Kraftl
<[EMAIL PROTECTED]> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
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
