Re: Formatting a DATE differently using SQL

[Robert Clay <zreclay@xxxxxxxxx>]

Chuck,

I like this [but it took me a bit of time to understand it] :-)

I hadn't used INSERT to actually //drop// characters before. A new 
addition to my SQL bag 'o tricks.

Thanks!

"Contrariwise, if it was so, it might be; and if it were so, it would 
be; but as it isn't, it ain't. That's logic."--Tweedledee

On 09/05/2013 3:04 PM, CRPence wrote:
>  <Snip>
>
>   The following expression is a much more succinct /solution/ for 
> forcing the value of the DATE data type to be cast to the 
> character-string with formatting of MM/DD/YY:
>
>     INSERT( CHAR( MIN(dayid), USA ), 7, 2, '')
</Snip>