ORA-01843: not a valid month

[tamade]

Does this work?

SELECT Type, Module FROM TableTypeModule
WHERE NVL(TRUNC(BeginDate), to_date('01.01.1800', 'dd.mm.yyyy')) <= TRUNC(SYSDATE)
AND TRUNC(EndDate) >= TRUNC(SYSDATE);