[Solved] MYSQL how to convert varchar to bigint

Question

Here you go:

select REPLACE(REPLACE(REPLACE('2017-10-10 23:59:21.087', '-', ''), ':', ''), ' ', '')

If it’s a field in a table, just do this:

SELECT REPLACE(REPLACE(REPLACE(forex_lastupdate, '-', ''), ':', ''), ' ', '')
FROM noksek_tickdata_copy;

Accepted Answer

Here you go:

select REPLACE(REPLACE(REPLACE('2017-10-10 23:59:21.087', '-', ''), ':', ''), ' ', '')

If it’s a field in a table, just do this:

SELECT REPLACE(REPLACE(REPLACE(forex_lastupdate, '-', ''), ':', ''), ' ', '')
FROM noksek_tickdata_copy;