Cacher is the code snippet organizer for pro developers

CAST(
		DAY(yourdate) AS CHAR( 2 )
	) || '/' || CAST(
		MONTH(yourdate) AS CHAR( 2 )
	) || '/' || CAST(
		YEAR(yourdate) AS CHAR( 4 )
	) AS Date,