to_timestamp function

From: Jaka Erjavec <jaka(dot)erjavec(at)voljatel(dot)si>
To: pgsql-general(at)postgresql(dot)org
Subject: to_timestamp function
Date: 2003-06-23 09:12:20
Message-ID: 200306231112.20668.jaka.erjavec@voljatel.si
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Arjen van der Meijden 2003-06-23 09:21:25 Re: [GENERAL] interesting PHP/MySQL thread
Previous Message Sander Steffann 2003-06-23 08:32:12 Re: PlPython