Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2014
    Posts
    1

    Unanswered: DB2 LUW 10.5 on Linux - Need help with DATE datatype

    I have defined many columns in my tables (DB2 10.5) on Linux as DATE. When we insert into them, the result is a TIMESTAMP.

    Why do I see TIMESTAMP in a date column?


    It was actually my mistake ...
    I was using a Microsoft editor and it is showing the date in timestamp format but the table is correct
    Last edited by sznnlnthr; 08-22-14 at 15:32. Reason: My mistake!

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Can you give examples? Also show the DESCRIBE for the table?

    Andy

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by sznnlnthr View Post

    Why do I see TIMESTAMP in a date column?
    One possible reason is Oracle compatibility mode.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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