test script for dates

date_test.sql

create table dbo.date_test
(
	date_test varchar(100)
)

insert into dbo.date_test values ('0');
insert into dbo.date_test values ('1901/01/01');
insert into dbo.date_test values ('error');
insert into dbo.date_test values ('2060/01/01');
insert into dbo.date_test values ('013/013/2060');
insert into dbo.date_test values ('28/12/2060');

select date_test as ori_date_test
, dbo.check_my_date (date_test) as my_function
from date_test