Thanks for replying.

I used the below code into derived column expression but it says invalid expression, invlaid token. i replaced the getdate() with the column name i need to convert.

(DATEPART( "Month", GETDATE() )<10?"0"+(DT_WSTR, 250)DATEPART( "Month", GETDATE() )DT_WSTR, 250) (DT_WSTR, 250)DATEPART( "Month", GETDATE() ))

+"/"+

(DATEPART( "Day", GETDATE() )<10?"0"+(DT_WSTR, 250)DATEPART( "Day", GETDATE() )DT_WSTR, 250) (DT_WSTR, 250)DATEPART( "Day", GETDATE() ))

+"/"+(DT_WSTR, 250) (DT_WSTR, 250)DATEPART( "Year", GETDATE() )

+" "+(DT_WSTR, 250) (DT_WSTR, 250)DATEPART( "Hour", GETDATE() )

+":"+(DT_WSTR, 250) (DT_WSTR, 250)DATEPART( "Minute", GETDATE() )

+":"+(DT_WSTR, 250) (DT_WSTR, 250)DATEPART( "Second", GETDATE() )