to_timestamp function
От | Jaka Erjavec |
---|---|
Тема | to_timestamp function |
Дата | |
Msg-id | 200306231112.20668.jaka.erjavec@voljatel.si обсуждение исходный текст |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: