Helgi Örn, 06.10.2010 20:36:
>> SELECT tid_in, to_char(tid_in, 'HH24.MI') AS format FROM timmar;
>>
> This does not work at all.
"Does not work" is not a valid Postgres error message.
What exactly is "not working"?
postgres=> create table timmar ( tid_in time );
CREATE TABLE
postgres=> insert into timmar values (TIME '23:24');
INSERT 0 1
postgres=> commit;
COMMIT
postgres=> SELECT to_char(tid_in, 'HH24.MI') AS format FROM timmar;
format
--------
23.24
(1 row)
If this is not what you want, you need to be more detailed.
Thomas