Is there any function in Oracle like 'MINDATE' or something which can be used to select the minimum date value from a field.
I have a date field called 'ENTDATE', and it can have 3-4 different date values.
Now, I just want to get the minimum of those 3-4 date values.
Basically, I want to use something like
But since it is a date field thus I can not use the MIN function.
Urgent help needed...!!