Re: Oracle Date

From: dreamer <1dreamer_at_home.com>
Date: Fri, 05 Mar 1999 15:01:16 GMT
Message-ID: <0lSD2.311$573.270_at_news.rdc1.md.home.com>


Yes, this will work. To test it out you may want to run a script similar to this:

select to_char(max(due_date),'dd-mon-yyyy hh24:mi') from temp;

BT wrote in message <36df490a.0_at_news.cyberway.com.sg>...
>Hi,
>
>Can I check if I have a field "Due_Date" of type DATE, will MAX(Due_Date)
>return me the record with the latest "Due_Date". Basically, I need to
>retrieve the record with the latest "DUE_DATE" from my table along with
some
>other conditions. Can anyone confirm this? Thanks!
>
>Boon TUN>
>
>
Received on Fri Mar 05 1999 - 16:01:16 CET

Original text of this message