Re: Need help with query in Oracle 8.1.7
Date: Fri, 24 Oct 2008 14:29:04 GMT
Message-ID: <QYkMk.7$Jv2.4@nwrddc01.gnilink.net>
"Brian K" <mailregdump_at_gmail.com> wrote in message
news:gEkMk.117894$sg2.86431_at_fe09.news.easynews.com...
> 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.
>>
>> -g
>
> 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
> 12:31:56'.
>
> 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
design decision.
Jim
Received on Fri Oct 24 2008 - 09:29:04 CDT