I have an application developed where the data submits to the below table on clicking submit button.
The table has below columns
create table X(
This table is already created in production environment. I now have a requirement to update the records of column C by adding timestamp, so that the precision of any newly inserted records from now would be captured. There are no chances of changing the datatype for the column from date to timestamp.
I'm confused as to what you're asking then. You can't change a field to a timestamp, if your not allowed to change the field to timestamp. That's just not possible.
Granted, date types vary from system to system, so it may be dependent on your system. For example, in MySQL DATE refers to java.sql.Date while DATETIME and TIMESTAMP both refer to java.sql.Timestamp. Interestingly though, they are all subclasses of java.util.Date. In other words, there's a lot of options depending on what your doing.