I have a table that stores a unix timestamp. To query this as a date, I'm attempting to convert this timestamp to a datetime type in a view. Unfortunately, I can only seem to get the DATE portion out.
This link describes how to do the conversion, but requires changing the nls_date_format
to include the time portion. The default currently only shows the date portion. I need the date and time.
Unfortunately, that solution only works at a session level. As a developer, I'd rather not have to go running off to our managed service provider to ask them to change the value at a database level - especially since it may impact other applications.
Is there a way I can convert the timestamp, in sql, to a datetime without modifying the system?