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
> create table tableX
> (
> datecolumn1 date
> )
> //
> Insert into tableX values(to_date('8/17/2000 12:00:00 AM','MM/DD/YYYY HH:MI:SS AM'))
> //
> Insert into tableX values(to_date('1/30/2030 12:00:00 AM','MM/DD/YYYY HH:MI:SS AM'))
> //
> Select TO_CHAR(datecolumn1,'MM/DD/YYYY HH:MI:SS AM') from TableX
> //
> returns:
> 08/17/2000 12:00:00 AM
> 01/30/2030 12:00:00 AM
> //
> Select TO_CHAR(datecolumn1,'MM/DD/YYYY HH:MI:SS AM') from TableX where
> datecolumn1=(Select max(datecolumn1) from TableX)
> //
> returns no rows (WHY???!!!) expect 01/30/2030 12:00:00 AM
> //
> Select TO_CHAR(max(datecolumn1),'MM/DD/YYYY HH:MI:SS AM') from TableX
> //
> returns
> 01/30/2030 12:00:00 AM
> //
> Select TO_CHAR(datecolumn1,'MM/DD/YYYY HH:MI:SS AM') from TableX where
> datecolumn1>(Select max(datecolumn1) from TableX)
> //
> returns
> 08/17/2000 12:00:00 AM
> 01/30/2030 12:00:00 AM
> (WHY???!!!) expect no rows
> //
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
