in the out put i have date in the 28/1/2013 format.
i want to change the date format in to 28 jan.
how can i get the 28 jan format in ms access database not in sql.
i wanted in MSAccess database.
how can i do.
i try the below query is not working
select CONVERT(varchar(11), Sch_Date, 106) AS schDate, [Session],[Faculty_Code] from Tb_SCh_TIme_Table
from my above query what is the mistake i made.help me. i tried but not get the 28 jan ouput.