Sqlite update date format?

hi everyone ,

if on sqlite you want to date format change

for example 2018/02/02  (Y/m/d) change 2018-02-02 (Y-m-d)

2017/01/06|username|password
update kota
set date = substr(date, 1,2)||substr(date,3,2)||'-'||substr(date,6,2)||'-'||substr(date,9,9)
where date LIKE '%/%/%'
2017-01-06|username|password