Formatting Timestamp - Need Assistance ! [CALC]

[grantlandau]

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!

[dajare]

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.)

[Xoristzatziki1]

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.

[grantlandau]

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.

[Xoristzatziki1]

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?