Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    21

    Question Unanswered: Inserting TIME???

    Hi all!!!

    Wich is the syntax for inserting TIME type columns in a DB2 v7.2 table?

    Thank you in advance!

  2. #2
    Join Date
    Mar 2003
    Posts
    33

    Re: Inserting TIME???

    I used different ways (db2 udb 7 linux):

    1) db2 "insert into mytable(time_col) values(current time)"

    2) db2 "insert into mytable(time_col) values('12.30.00')"

    3) db2 "insert into mytable(time_col) values('12:30:00')"

    all succesfully.




    Originally posted by rgarcia
    Hi all!!!

    Wich is the syntax for inserting TIME type columns in a DB2 v7.2 table?

    Thank you in advance!
    -r-

  3. #3
    Join Date
    Jan 2003
    Posts
    21
    Thank you very much!

Posting Permissions

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