How convert DateMask to style in T-SQL?

N4Nd0

New Member
I have some custom DateMask as example 'yyyy/MM/dd'.How can I get style from this DateMask for function CONVERT( data_type [ ( length ) ] , expression [ , style ] ) ?Maybe available some converting functions already?PS. Variant as CONVERT( datetime, '2012/07/14', 111) is not flexible for me. I want next realization if this possible\[code\]CONVERT( datetime, '2012/07/14', getStyleFromMask('yyyy/MM/dd'))\[/code\]
 
Top