how to get date in different formate in sql
hi all ,
i get data from sql server and in data has one date like 1/2/2010 ..... and time also
but the client wants the date format like this if date comes from sql store producer is 1/2/2010 then client want this date into 1-feb-2010 how i convert date in sql store producer
to convert date 1/1/2010 to 1-Jan-2010 in sql store producer please hell me