UK Date format to DD/MM/YYYY

[kizziebutler]

I am converting a date but it coming out as YYYY-MM-DD, I am trying to convert the date to display as dd/mm/yyyy with "/" but not quite there can you help!!!!

This is what I am using:

+'|'+ISNULL(CONVERT(VARCHAR10),NTCKnownFacts.Date_of_Birth,120),'')

 

[AtomicWedgie]

select CONVERT(VARCHAR(10),getdate(),103)

regards,

atomic wedgie

 

[kizziebutler]

Thank you.