Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008

    Unanswered: To store just Time information in Oracle column

    Hi All

    I am moving data from MS Access to Oracle.
    In MS Access, we have Date (Short Date) field stores just time information like 07:00 AM, 12:29 PM etc.
    While moving data from MS Access to Oracle (Date datatype), along with time values (07:00 AM, 12:29 PM), some default date also is getting stored.
    The target value getting stored currently is 12/31/1899 07:00 AM, 12/31/1899 12:29 PM.

    I don't want 12/31/1899, I need just time information. How to achieve this one?


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts