Currently the Time column within the SYSLOGD table is set to varchar2 (which is a text datatype). The application doesnt allow date conversion using Oracle date functions within the custom date window.
I noticed there is a text file that holds the INSERT statement into the SYSLOGD table and I would like to modify that text file so that it converts the time value into 24hour clock.
Has anyone every attempted this before? Or is there another way to convert the Time Value into 24 hour clock?
