OK, here is the simple way in one go...
{
Control via the Date Time Format Seq to match the input
Don't mess with functions, they won't convert in one go to DateTime
temp table StWills has Three cols:
One Date and One Time one Computed to DateTime
}
SET DATE FORMAT DD-MMM-YYYY
SET DATE SEQUENCE ddmmyyyy
SET TIME FORMAT HH:MM:SS AP
SET TIME SEQUENCE hhmmss
SET VAR vstr = '03-Oct-2007 01:23:38 PM'
INSERT INTO stwills coldate, coltime SELECT (SGET(.vstr,11,1)),
(SGET(.vstr,11,13)) FROM dummy
RETURN
