How to validate date field in dd/mm/yyyy or yyyy/mm/dd format ?

Database
Enthusiast

How to validate date field in dd/mm/yyyy or yyyy/mm/dd format ?

I was trying to write a SQL which would validate a date column field. The validation would be whether the rows have data in 'dd/mm/yyyy' or 'mm/dd/yyyy' format.