Originally posted by calico
I'd like to know what advantages there are for using different time formats?
I am currently redeveloping an old database and the date/times can be found in Julian, Epoch, and YYYYDOY formats. Should I convert all to Oracle date/time?
If so, which oracle format and how much accuracy do these have?
I would definitely recommend changing these various formats to the Oracle DATE format - or TIMESTAMP if sub-second accuracy is required. Then you will be able to perform date arithmetic easily and consistently.
If you have any legacy code that requires seeing the dates in some particular format, you can give it a view that provides the required format, either through TO_CHAR and a format mask, or via a bespoke function.