用于根据另一列上的前六位数设置DOB的SQL脚本

i need to write a SQL script to update the DOB column based on another column where come with 12 digits of number and the first 6 digits is the DOB.i need to write a SQL script to update the DOB