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

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