[Solved] MYSQL how to convert varchar to bigint

by

[ad_1]

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;

2

[ad_2]

solved MYSQL how to convert varchar to bigint