Hi,
This is my test case!!
regards,
Ajit
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
