R_life_R
R_life_R

Reputation: 816

Convert MySQL date with milliseconds to Google Sheets' date format

I have the following string in Google Sheets, extracted from a MySQL date format:
2018-05-28 23:10:23.477

I need it to be converted to a date format in Google Sheets, including the milliseconds.

Upvotes: 1

Views: 462

Answers (1)

pnuts
pnuts

Reputation: 59475

Please try:

=text(A1,"yyyy-mm-dd hh:mm:ss.000")-0

Upvotes: 1

Related Questions