Data conversion tasks

[getsatish_gk]

Hi, i m facing issue at

converting date (yyyy-mm-dd) to dd/mm/yyyy
converting date (dd-mon-yyyy) to dd/mm/yyyy

i tried unsuccessfully with convert function..

can any one came across such tasks?

[ray.wurlod]

They are fairly frequent requirements. However, Convert() would not be the correct function to use, as it effects character-by-character replacement. The actual solution will depend on the data type of the input column and the output column, but will involve some combination of DateToString() and StringToDate() with appropriate date format strings.