Hi all,


I have a small database procedure that on insert into tableA, it inserts a
related row into tableB
Where currently it uses

<snipped for brevity of course>
Insert into std_activity_references (:std_activity_no,'WP Rev
Date',char(date('today'),10) )
<snip...>

Where because ii_date_format is set to Multinational4, the dates thus
inserted are in the form dd/mm/yyyy.

Is there any simple way of formating the dates so that it is inserted into
the record in the format dd-mmm-yyyy


Someone suggested using set date_format='US' in the procedure, but did say
that this method is fraught..


I tried it in an isql session, but it did not seem to make any difference.



II_DATE_FORMAT =MULTINATIONAL4 is set in each PC's system environment
variables, and in the servers, and using INGSETENV


Installation is II2.6sp3 on Solaris 7 on sparc.


TIA.


Cheers

Richard

/**********************************\
| New Zealander, leading the world |
\**********************************/