Re: Distinct not working when convert DATE using TO_CHAR

Following is the data:

 Number Date

• ------------------- 26 12/19/2005 13:57:05 26 12/19/2005 13:57:07 27 12/19/2005 13:57:29 27 12/19/2005 13:57:31 28 12/19/2005 13:57:54 28 12/19/2005 13:57:55

and the actual query:

select Field1 "Number", to_char(time, 'MM/DD/YYYY HH24:MI:SS') "Date" from audit_iedata where ( time >= to_date('19-DEC-2005 13:00',
'DD-MON-YYYY:HH24:MI') and time <= to_date('19-DEC-2005 14:00',
'DD-MON-YYYY:HH24:MI'));
How can I get only first occurence of Field1 ? ie:

 Number Date

• ------------------- 26 12/19/2005 13:57:05 27 12/19/2005 13:57:29 ....