WebDB 2.2. Date format problem?

Creating a Report:

    One of the fields in the select clause has a date datatype.     I would like to get it in the following format :

        'DD-MON-YYYY HH24:MI:SS'
    I have specified this format in the Format Mask field in the Column Formatting of the Report but the time is allways 00:00:00. If I do the same select in a SQL session, I get different times...

[Quoted] I don't see why!! Am I doing sth wrong? Am I forgetting sth?

Any help will be welcome,
Thank you very much in advance.
Montse Collados Polidura
CERN - Switzerland. Received on Fri Feb 04 2000 - 16:07:00 CET