> 1. You need to use Postgres idioms for the reformatting of the date.
>
> <http://www.postgresql.org/docs/9.0/static/functions-formatting.html>
>
> 2. You put in a syntax error when you put in an extra comma.
>
> Instead of:
>> SELECT pack_tidin TIME_FORMAT, pack_tidin '%H.%i', AS format FROM timmar;
> ^
> Take out the comma to get:
> SELECT pack_tidin TIME_FORMAT, pack_tidin '%H.%i' AS format FROM timmar;
>
> Possibly a more suitable query would be:
>
> select pack_tidin, to_char (pack_tidin, 'HH.MI') as format from timmar;
>
This works fine, the only problem is the outcome the two columns:
pack_tidin | format
------------+--------
07:45:00 | 07.45
08:00:00 | 08.00
07:00:00 | 07.00
06:30:00 | 06.30
This is precisely what I wanted:
ekobas=# SELECT to_char(pack_tidin, 'HH24.MI') AS format FROM timmar;
format
--------
07.45
08.00
07.00
06.30
> I'm assuming that '%H.%i' is intended to return hours and minutes,
> separated by a ".". You can probably get more useful guidance from the
> URL listed above.
>
Yes, the time format in the database is hh:mm:ss which I do not want
om my page, I want this hh.mm which is quite common in at least in
europe.
Thank's,
/HÖ