Re: SQLLOAD and TIME value into DATE/TIME column?
From: Randy Bradley <bradley_at_marcvm.marc.usda.gov>
Date: 1995/05/11
Message-ID: <bradley.1150573942B_at_aux>#1/1
Randy Bradley | Systems Analyst | US Meat Animal Research Center | Clay Center Computer Spec.| 402-762-4156 | bradley_at_aux.marc.usda.gov | Nebraska
"Around it! Around it! Confoundit. Nobody gave me the specifications. I have to do everything myself around here." Gopher-The Great Honeypot Robbery
Received on Thu May 11 1995 - 00:00:00 CEST
Date: 1995/05/11
Message-ID: <bradley.1150573942B_at_aux>#1/1
Everyone,
To answer my own question, YES, the sqlload utility does indeed recognize
the time component of the date mask. Works like a champ.
My mistake was actually when I used sqlplus to check the table, I assumed
that TO_CHAR(column_name) would show both the date and time by default.
However, it only shows the date by default ( In a very, very wide field :-).
When I used the format field of the TO_CHAR() function, it indeed showed the
time component I loaded with sqlload :-)
Happy Again,
Randy
Randy Bradley | Systems Analyst | US Meat Animal Research Center | Clay Center Computer Spec.| 402-762-4156 | bradley_at_aux.marc.usda.gov | Nebraska
"Around it! Around it! Confoundit. Nobody gave me the specifications. I have to do everything myself around here." Gopher-The Great Honeypot Robbery
Received on Thu May 11 1995 - 00:00:00 CEST