Viewing post 1 (of 1 total)
select substring(cast(settledate as varchar(10)),6,2)+ '/'+ substring(cast(settledate as varchar(10)),4,2)+ '/' + substring(cast(settledate as varchar(10)),1,4)as SettleDate from table1
Hope this shold work.
Thanks,
Hanu
May 1, 2008 at 8:38 am
#809607