Finding which DATE columns have no time data using TRUNC
This is because the data representation of dates depends on your NLS settings.

You can change the representation of dates for your current SQL statements before you issue your first command by using the following command:

alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';


Or seeing as you are using the slash notation:

alter session set nls_date_format = 'dd/mm/yyyy hh:mi:ss am';


If you then having a column containing a date format, then it should be returned as:

29/06/2002 1:50 pm


References


Setting Up a Globalization Support Environment (Oracle Docs)