Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help!!!
Try
select max(date filed) from table ;
Chen Li wrote:
> Hi, all
>
> I want to select a record which has the latest date. But the date
> consists of two field: date
> (YYYY:MM:DD) and time(HH24:MI:SS). How to do that? Thanks in advance.
>
> Simon
Received on Wed Jun 02 1999 - 22:53:50 CDT