Re: Alternative to AS?

On 6 October 2010 21:07, Thomas Kellerer <spam_eater@gmx.net> wrote:
> 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"?
>
It didn't work and the outcome was none at all. Before, the prompt had
changed from ekobas=# to ekobas'#?

> 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
>
I AM SO VERY SORRY TO ALL OF YOU GUYS!
I made a dreadful mistake when I created this tabel I call "timmar"
(hours, that's working hours), it includes three TIME columns which I
created in phpPgAdmin which shows very small letters on my computer.
Two of these columns started with capital P instead of p. Terrible
mistake, me bad :(

This works very well:
SELECT tid_in, to_char(tid_in, 'HH24.MI') AS format FROM timmar;

Thank you all for your effort.

/HÖ