time format

[sarovb]

Hi
Table ABC which contains column TRAN-TIME NUM 0 0 0 ^^:^^:^^.^^ (number - time format datatype) in C-ISAM database, Is there any way to convert this time format to oracle db .
I think oracle won't support TIME format alone. it will support both DATE with TIME.

I need to migrate this time format data to oracle.

Any solutions

[rajabalachandra]

hi,

if you omit time it will be 00:00 midnight.

[Thomasps]

load the TIME and DATE values to a Oracle TABLE as string, then use PL/SQL to format and convert to Oracle DATE format. Since time is a column, there must be date column. Any other better method..?

[abhaysk]

Originally posted by Thomasps
load the TIME and DATE values to a Oracle TABLE as string, then use PL/SQL to format and convert to Oracle DATE format. Since time is a column, there must be date column. Any other better method..?

First of all did he say he had Date String Values? According to my read he has only Time Strings and asking whether can have just time part in Oracle DB..

[Thomasps]

What is the logic of having time with out a date column..??? So I assume he got date into separate filed. sarovb, can you clear it..?

[abhaysk]

Originally posted by Thomasps
What is the logic of having time with out a date column..???

I dunno, but i only go with what is said and asked..coz before when i assumed and answered i got real beat up from MODS