oracle min function

[Manon Baratt]

Hi,

Is there a problem with Oracle min function. I am using it to get the min date. I should return 9/2/1997 but I get 10/23/1989.

This is my query:

select min(t.effective_start_date) from assignments t where t.job_id = '1'

Thanks.

[Manon Baratt]

Sorry, lack of sleep can make one make stupid mistakes. It is working correctly.:-)