Avatar of Sam OZ
Sam OZ
Flag for Australia

asked on 

Sql server query to convert date

I have an Sql server 2016 table TB_Doc where the field creationdate is a varchar field
sample value :  2019/02/21-03:02:32:051
I am looking for an sql query to get the dd/mm/yyyy  value out of it
for example in this case I should get  21/02/2019 
SQLMicrosoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon