Re: Need help with query in Oracle 8.1.7
Date: Fri, 24 Oct 2008 14:29:04 GMT
"Brian K" <mailregdump_at_gmail.com> wrote in message
> On Fri, 24 Oct 2008 06:39:42 -0700, gazzag wrote:
>> On 24 Oct, 13:23, "Shakespeare" <what..._at_xs4all.nl> wrote:
>>> ============================================== Wouldn't a select max( )
>>> group by
>>> be enough to do the job?
>>> Shakespeare- Hide quoted text -
>>> - Show quoted text -
>> Insufficient data :)
>> I was wondering where PL/SQL came into it.
> I will post schema and some sample data.
> The main problem I'm having is that the date field is date formatted, but
> they neglected to include the actual time.
> So, when I'm trying to do date/time functions I invariably end up trying
> to parse the date and time as something like '10-Oct-08 00:00:00
> Well, the main problem is actually my complete ignorance of oracle
> functions, but that's beside the point.
It isn't date formatted it is a string representing a date - a classicly bad
Jim Received on Fri Oct 24 2008 - 09:29:04 CDT