Hi Radosaw,

You need to look at the settings of the environment variable
II_DATE_FORMAT. This is documented in the SQL reference guide.
There is a table of the various permitted input formats, and output
formats.

The default date format is 'US', but you may set alternatives as follows.

At an installation wide level using ingsetenv. You can display the
current installation setting with ingprenv II_DATE_FORMAT.

You can also set the environment variable for a specific job or session.
This 'local' setting would then override the installation setting - for the
lifetime of the session/job or until this local setting is altered or cleared.

In your case, you could use:

setenv II_DATE_FORMAT DMY
sql iidbdb
select date('27-03-2006 10:22:01');\g
\q

The system will respond with a date in DMY 'output' format of:
dd-mmm-yyyy

Martin Bowes

Hi Martin,
This is it. Thans a lot. I own you pretty big beer .

Regards
Radoslaw Witkowicki
<martin.bowes (AT) ctsu (DOT) ox.ac.uk> wrote