I’m attempting to format a timestamp on a document that I received from a vendor.
FORMAT RECEIVED:
2016-01-04 15:33:47.000000 CET+0100
FORMAT CONVERTING TO:
2016-01-04 15:33:47 +0000
I can very easily format the column as text, but my database importer does not accept the formatting as text. I believe that I need to retain the timestamp formatting in LibreOffice, however I’m not very familiar with the process. I’ve done formatting changes for simple timestamps using HH:MM:SS etc. This format is a little more complicated -
Please help!