hi, i was looking for some help in regards to adding data that has time and date values but im not sure if i have added the right datatypes as whenever i insert the data i dont get the same data output.
the following is my create table query:
CREATE TABLE table1
(
Time_Key varchar (255),
Begin_Time timestamp(6),
Abandoned interval day(0) to second(6)
)
an example of the data that i am trying to add looks like the following:
TimeKey: 201311110000GMT
Begin Time: 11/11/2013 00:00:00
Abandoned: 00:00:00
but once i input this data through sql developer the output i get is the following which isnt correct.
TimeKey: 201311110000GMT
Begin Time: 11-NOV-2013
Abandoned: 01-DEC-2013
not sure where i am going wrong, any advice would be really appreciated.
Thanks in advance.