Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Jacob Mahto
Added: Jul 20, 2018 3:55 AM
Views: 4
Tags: no tags
  1. UPDATE studentinfo SET dob=concat(SUBSTRING(dob,1,2),"/",SUBSTRING(dob,3,2),"/",SUBSTRING(dob,5,4)) WHERE CHAR_LENGTH(dob)=8
  2.