DataBase: Oracle 10
-- Situation 1
In Business Table Properties :::
Date field type > Miscellaneous > Mask for Number or Date > I tried two ways: DD/MM/YYYY HH24:MI:SS and 'DD/MM/YYYY HH24:MI:SS'

In Query Editor..., Selected Columns > field date type and outhers.
Results were indifferent. Had no effect!

-- Situation 2
In Business Table Properties :::
Date field type > Calculation >
Formula: to_char(field_A,'DD/MM/YYYY HH24:MI:SS')
>
Checked - Is the Formula Exact?

In Query Editor..., Selected Columns > field date type and outhers.
the result of the mask was good

Why is a situation 1 did not work?

-----
In both cases, i tried add the filter condition (Query Editor).
But in both cases the condition did not work.

There was an error during query generation.
org.pentaho.pms.core.exception.PentahoMetadataException: DefaultSQLDialect.ERROR_0001 - Date string syntax "01/04/2010 00:00:00" is invalid.

Why?