Simple Date Format
447620Apr 14 2008 — edited Apr 14 2008Hi,
I have an entity object with some attributes, one of them is called "CREATED_ON", which i have specified as a history column (created on).
I have specified a format type of Simple Date in my Control hint and a format of dd-MM-yyyy. I then created a view based on my entity and dragged the view as an adf creation form. I also dragged a commit button to commit my record.
However, the date that is stored in my database have a non-zero time component (e.g. 10-JUL-2007 10:46:22). This is a problem becuase in my search form, the search criteria does not work (it requires the exact time also to work). I do not want to use TRUNC in my SQL query.
Instead i want the date to be stored with the format mask that i have specified.
Can you please help me?
Thank you