Timestamp with time zone problem

From: Aguinaldo Fagundes Junior <Aguinaldo(dot)Fagundes(at)vantcom(dot)net>
To: 'pgsql' <pgsql-sql(at)postgresql(dot)org>
Subject: Timestamp with time zone problem
Date: 2002-03-11 14:37:12
Message-ID: 734932D6EA60D511A13600508BDE72480E225D@slentms1.vantcom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello all!

I'm trying to insert a record in a 'timestamp with time zone' field but i
get an erro message:

ERROR: to_timestamp(): TZ/tz not supported.

My used sql command is:

insert into raddb values
('192.168.1.1', 'Async', 'Nameteste',
'called','calling','Stop',
'Login-user', 'session-id',
to_timestamp('14:11:58.107 UTC Fri Mar 8 2002','HH24:MI:SS.MS TZ Dy Mon DD
YYYY')
);

and my table is described as:

1 nas_ip_address | character varying(30) |
2 nas_port_type | character varying(30) |
3 user_name | character varying(30) |
4 called_station_id | character varying(30) |
5 calling_station_id | character varying(30) |
6 acct_status_type | character varying(30) |
7 service_type | character varying(30) |
8 session_id | character varying(30) |
9 call_leg_setup_time | timestamp with time zone |
10 gateway_id | character varying(50) |
11 connection_id | character varying(50) |
12 call_origin | character varying(30) |
13 call_type | character varying(30) |
14 connect_time | timestamp with time zone |
15 disconnect_time | timestamp with time zone |
16 disconnect_cause | character varying(30) |
17 remote_ip_address | character varying(30) |
18 acct_input_octets | integer |
19 acct_output_octets | integer |
20 acct_input_packets | integer |
21 acct_output_packets | integer |
22 acct_session_time | integer |
23 acct_delay_time | integer |
24 client_ip_address | character varying(30) |

I'm using postgres 7.2.0 but in 7.1.3 I got the same result.

What can be wrong in this statement? Can anybody help me?

Browse pgsql-sql by date

  From Date Subject
Next Message Mike Finn 2002-03-11 18:19:00 Calling a trigger from a trigger
Previous Message Dag Arne Matre 2002-03-11 10:54:44 Re: where not exists