create table #a (s varchar(8), t varchar(8))
insert #a select '03/13/41',
'09/06/83'
insert #a select '04/16/52', '03/29/79'
insert #a select
'09/07/50', '02/12/92'
insert #a select '04/30/62', '02/26/92'
insert #a
select '04/11/61', '04/10/92'
insert #a select '06/25/54',
'06/01/92'
insert #a select '03/27/65', '10/03/95'
insert #a select
'12/02/56', '07/07/78'
insert #a select '10/14/48', '06/11/90'
insert #a
select '01/18/42', '01/07/81'
insert #a select '04/07/59',
'11/15/91'
select convert(datetime,s,1), convert(datetime,t,1) from #a
No comments:
Post a Comment