how to get date in different formate in sql

Question

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

Answer 1

hi,

you could find date format and convert to which you want show here

Example

Answer 2