Re: Alternative to AS?

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