Date format within LOV is driving me mad !?*
740977Dec 14 2009 — edited Dec 16 2009I have an LOV that is displaying the date differently has anyone got a clue what is doing it?!*
In a table view 'view_f_usas_demands_pdm' the date format is eg. 29-NOV-05 12.00.00.000000
When displayed in the dates in an LOV using the following select statement the date has an AM eg. 29-NOV-05 12.00.00.000000 AM tagged on the end.
SELECT dmd_date d, dmd_date r
FROM view_f_usas_demands_pdm
WHERE dmdno = :P7_DEMAND_NUMBER
ORDER BY d
I have checked and I cannot see any format masking inserted also in shared components, edit attributes the application date format is blank.
I have doubled checked the view table the data is coming from in sql developer and it has no AM's.
Any clues ?!