Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2008
    Posts
    16

    Unanswered: Store time alone in Database

    Hi,

    I have created a table in which one field is time datatype is date (because there is no any datatype like datetime in oracle).

    Actally I want to store only time in this field. But when we input only time through Form6i it will store time like 01-Jul-06 20:50.

    Actually I want to store only time in that field like 20:50.

    Please suggest favourable solution.

    Thanks,
    Vijay

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    You can not; not into the DATE datatype column, actually.

    Check this recent thread; perhaps it'll help.

Posting Permissions

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