Hi Gustav,
That was a good idea but it doesn't work
Select TO_CHAR(aliasx.datecolumn1,'MM/DD/YYYY HH:MI:SS AM') from TableX aliasx where
aliasx.datecolumn1=(Select max(aliasy.datecolumn1) from TableX aliasy)
still returns no rows.
is it a known SAP-DB bug? Can anyone confirm?
pls. anyone who finds a workaround let me know.
regards,
Ajit
-----------------------------------------------------------------------------------
Message: 2
Date: Thu, 27 Feb 2003 11:30:31 +0100
From: Gustav Brock <[EMAIL PROTECTED]>
Reply-To: Gustav Brock <[EMAIL PROTECTED]>
Organization: Cactus Data ApS
To: [EMAIL PROTECTED]
Subject: Re: Bug in date comparison
Hi Ajit
Have you tried an alias for TableX in the subquery?
Select
TO_CHAR(datecolumn1,'MM/DD/YYYY HH:MI:SS AM')
From
TableX
Where
datecolumn1 In
(Select
Max(aliX.datecolumn1)
From
TableX As aliX)
/gustav
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
