Nov 10, 2011

how to change the varchar to date in sql server

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