Home » SQL & PL/SQL » SQL & PL/SQL » insert data for timestamp with time zone
insert data for timestamp with time zone [message #189801] Sun, 27 August 2006 21:47 Go to next message
Messages: 254
Registered: June 2005
Senior Member
if i want to know the timezone for a date column, i have

to use timestamp with time zone data type, which i believe is

valid only from version 9.., but how to insert data, i have

done the following

  1* create table test_date(x timestamp with time zone)
SQL> /

Table created.

SQL> insert into test_date values('24-AUG-06');
insert into test_date values('24-AUG-06')
ERROR at line 1:
ORA-01840: input value not long enough for date format

so how to insert data for such data type, and how to know

the timezone used?

Re: insert data for timestamp with time zone [message #189850 is a reply to message #189801] Mon, 28 August 2006 02:00 Go to previous message
Messages: 53
Registered: April 2005
Location: Bangalore

plz refer to this


With Regards
Previous Topic: executing a package.procedure
Next Topic: Problem with the function
Goto Forum:

Current Time: Wed Oct 26 09:03:03 CDT 2016

Total time taken to generate the page: 0.12619 seconds