select AID, (cast (ADatec as varchar(30) )+ '('+convert(Varchar(10),ADated,121)+')') as ADate from A
癸未年正月初四(2004/02/4) select AID, (cast (ADatec as varchar(30) )+ '('+convert(Varchar,ADated,111)+')') as ADate from A 癸未年正月初四(2004-02-4) select AID, (cast (ADatec as varchar(30) )+ '('+convert(Varchar,ADated,121)+')') as ADate from A
select AID, (cast (ADatec as varchar(30) )+ '('+convert(Varchar,ADated,111)+')') as ADate from A
癸未年正月初四(2004-02-4)
select AID, (cast (ADatec as varchar(30) )+ '('+convert(Varchar,ADated,121)+')') as ADate from A