If you are wanting for example, to present a date in the format '18-Jan-2006' to match an Oracle default; you will need to create a new Custom DB format, and then amend the log to ODBC Action, to select the new format.

As follows:

1.  within Kiwi Syslog Daemon | Setup Properties | Formatting, Add a new Custom DB format.
2.  change the type = Oracle database. Select the date field with a tick.
3.  in the Date Format field, amend the 'YYYY-MM-DD' to 'YYYY-MMM-DD'. (It's an editable field).
4.  change the the size field from 10 to 11, to take into account the additional char in the date format field i.e 'MMM'

Now if you press the 'Show SQL commands', the date should be how you want to see it.

5. Give your new format a name i.e x format
6. Amend your 'Log to ODBC' Action by selecting the new custom DB format name from the 'Database type/field format' drop down list
(it will be at the very bottom of the list e.g custom1 - x format)