Formatting Timestamp - Need Assistance ! [CALC]

I’m attempting to format a timestamp on a document that I received from a vendor.

2016-01-04 15:33:47.000000 CET+0100

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!

How do you “receive” this data? Can you process the conversion before bringing into Calc? (And I assume this is about spreadsheet? You haven’t tagged it with Calc, and you don’t explicitly specify.)

First you must provide to us which is the “importer” and what the importer expects. Because the importer expects a type. For example may expects a text in format YYYYMMDD, or an integer starting from X day, etc. etc.

I received this data as a CSV and imported to another program also as CSV. I don’t know how to process it before moving it into calc, I don’t really have any other editing software other than LibreOffice. The importer program is looking for YYYY-MM-DD HH:mm:ss Z as a format. The Z is the offset and I can’t seem to get Libre to format the offset.

I initially just tried converting the data to text and doing a replace function, but csv doesn’t work like that.

When opening a CSV with Calc you can change the format of imported columns, by clicking on the sample column and changing the type of just this column. Have you tried this?