select
Company, PIN, Type, convert(varchar,convert(datetime, DateFrom, 103),112) as df
from sheet1
where Type in (’01’,’02’,’03’,’04’,’05’)
Advertisements
{ studyIt(); knowIt(); useIt(); }
November 20, 2007
DATABASE : MS SQL SERVER Leave a comment
select
Company, PIN, Type, convert(varchar,convert(datetime, DateFrom, 103),112) as df
from sheet1
where Type in (’01’,’02’,’03’,’04’,’05’)
Leave a Reply