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

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

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

    thanks

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    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
  •