Обсуждение: to_timestamp function

Поиск
Список
Период
Сортировка

to_timestamp function

От
Jaka Erjavec
Дата:
Hello,

I managed to establish postgresql support for accounting  in Freeradius. It is
logging all of the radius attributes (including Cisco h323) in the database,
but the problem is that all this h323 Cisco attributes are set to type
string.
I found this postgresql function called to_timestamp(), which should be able
to convert string in to date. The problem is that Cisco's time format
(13:17:22.670 CET Fri Jun 20 2003) somehow does not get completely recognized
when using the function in the following way:

radius=# select to_timestamp('13:17:22.670 CET Fri Jun 20 2003','HH24:MI TZ
Day Mon DD YYYY');
ERROR:  to_timestamp(): TZ/tz not supported.


So, the question is, what am I doing wrong or is there some bug in this
function.

postgresql version:
radius=# select version();
                               version
---------------------------------------------------------------------
 PostgreSQL 7.2.4 on i386-portbld-freebsd4.8, compiled by GCC 2.95.4
(1 row)


Thank you!

Jaka