Exposition: I have an oracle database table with date format as 'mm/dd/yyyy' and an unique constraint that contains the date column. My issue is that I can't seem to find a method to change the internal date format, which I need to get down to the second (ie 'mm/dd/yyyy hh12:mi:ss'). I do NOT want to change the query of the output format, I want to change the stored value to be updated.
Question: Is it even possible to get the database precision down to the second? If so how, I assume its an update or alter command?