Home Forums SQL Server 2008 T-SQL (SS2K8) Convert Text to Date DataType RE: Convert Text to Date DataType
roryp 96873
SSCertifiable
Points: 6649
More actions
August 14, 2012 at 11:27 am
#1525685
Try something like this:
select CONVERT(date, mydate, 103)
from mytable