字符串转 timestamp
input: ‘2017/10/30 16:20:24.000000000’
select from_unixtime(unix_timestamp('2017/10/30 16:20:24.000000000','yyyy/MM/dd HH:mm:ss.SSSSSSSSS'),'yyyy-MM-dd HH:mm:ss.SSSSSSSSS')
output: 2017-10-30 16:20:24.000000000
字符串转 timestamp
input: ‘2017/10/30 16:20:24.000000000’
select from_unixtime(unix_timestamp('2017/10/30 16:20:24.000000000','yyyy/MM/dd HH:mm:ss.SSSSSSSSS'),'yyyy-MM-dd HH:mm:ss.SSSSSSSSS')
output: 2017-10-30 16:20:24.000000000