Re: Calc. diff. of dates in min.

bhavinsh wrote:
>
>
> Hi,
>
> How do you get a difference in two oracle dates
> (format = 'DD-MM-YYYY HH24:MI:SS') in minutes?
> Are there any oracle functions that will do
> this?
>
> Oracle 8.1.6
> Red Hat 6.0
>
> Thanks in advance.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

    trys using the to_char function
    Ex: to_char(datehired, 'fmDdspth "of" Month YYYY fmHH:MI:SS AM')

--
Posted via CNET Help.com
http://www.help.com/