Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: insert datetime into a db2 mm/dd/yyyy field

    I have a program that takes the date of today and inserts it into a db table. however is mm/dd/yyyy and wont be accepted by the db2 database. how do i truncate it so it only inserts the date not the date and time.


  2. #2
    Join Date
    Nov 2004

    date versus timestamp

    you can always convert this string to date with substring
    and create a string 'yyyy-mm-dd'
    will check if any builtin function for this
    Best Regards, Guy Przytula

Posting Permissions

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