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
gautamvv
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
venkatbollu
Messages: 53
Registered: April 2005
Location: Bangalore
Member

plz refer to this

http://www.psoug.org/reference/timestamp.html

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


Current Time: Tue Dec 06 16:00:44 CST 2016

Total time taken to generate the page: 0.12212 seconds