I have the following problem:
I am using an archiving software that exports its data to an MS SQL database, one of the columns being designated Timestamp_S (which represents the unix time), and it is an 32 bit integer.
This database needs to be queried by a different reporting software. The problem is that the reporting software requires its entries to have a field named "Timestamp" and also that the data type be SQL timestamp.
I am currently trying to select the data that the archiving software is sending and format it so that the reporting software can use it.
Seeing that you cannot convert any data type to timestamp, does anyone know a work-around for this problem?
Any help is appreciated!