Results 1 to 3 of 3

Thread: Help

  1. #1
    Join Date
    Dec 2004
    Posts
    2

    Unanswered: Help

    Hi

    Will my database table get corrupt if i load date values in text type fields ?

    regards
    K

  2. #2
    Join Date
    Oct 2004
    Posts
    145
    It should not get corrupted.

    Only questions would be is, if know it is date why would you store it as character/text?

  3. #3
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    Oracle does dynamic type casting where possible. This is one of those cases where it is possible, so Oracle does it. No corruption will occur.

    There are two basic ways of putting a date into a text field.
    1. date function --> text field
    2. date string --> text field.
    In the first case, Oracle automatically casts the date as text. In the second case, the date is already a string and no casting is necessary.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

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