Sql server String to Date conversion

Example:
select convert(date,format(Getdate(),'yyyy')+'/'+format(Birthdate,'MM')+'/'+format(Birthdate,'dd')) from Employee
Result:

Post a Comment

0 Comments