i create a data block using table emp and set the hiredate to hh24:mi:ss format
when i change the hour/minute and save the form it will change the hiredate to first day of month.
i want to keep the hiredate as it was but i want to change the hour/minute,how ?
Your question is not clear.
Please re post your question.
However.. Oracle always store date file with date, time including HH and seconds.
When you change date column, you can change everything as per your format of fileld.
So recheck your code and post here if needed
i want to keep only hh24:mi:ss.
your answer is write , when i set the date in your format. it would not changed. but when i set the format in hh24:mi:ss then it become changed.