CAST - Revision history

http://www.sqlzoo.net/w/index.php?title=CAST&feed=atom&action=history CAST - Revision history 2013-06-18T06:33:16Z Revision history for this page on the wiki MediaWiki 1.20.4 http://www.sqlzoo.net/w/index.php?title=CAST&diff=4109&oldid=prev Peter at 09:39, 1 October 2012 2012-10-01T09:39:50Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 09:39, 1 October 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 26:</td> <td colspan="2" class="diff-lineno">Line 26:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">{{Languages}}</ins></div></td></tr> </table>

Peter http://www.sqlzoo.net/w/index.php?title=CAST&diff=1348&oldid=prev Connor at 14:35, 16 July 2012 2012-07-16T14:35:42Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 14:35, 16 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 26:</td> <td colspan="2" class="diff-lineno">Line 26:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;"><p>See also</p></del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;"><ul></del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">  <li>[[CONVERT function]]</li></del></div></td><td colspan="2"> </td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;"></ul></del></div></td><td colspan="2"> </td></tr> </table>

Connor http://www.sqlzoo.net/w/index.php?title=CAST&diff=1204&oldid=prev Connor at 11:54, 13 July 2012 2012-07-13T11:54:12Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 11:54, 13 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 20:</td> <td colspan="2" class="diff-lineno">Line 20:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>You can also CAST a date to a string to extract components using SUBSTRING or make up another date.   </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>You can also CAST a date to a string to extract components using SUBSTRING or make up another date.   </div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SELECT CAST(population/1000000 AS DECIMAL(8,1)) AS a</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>SELECT CAST(population/1000000  </div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">      </ins>AS DECIMAL(8,1)) AS a</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       ,population/1000000 AS b</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       ,population/1000000 AS b</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM bbc</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM bbc</div></td></tr> </table>

Connor http://www.sqlzoo.net/w/index.php?title=CAST&diff=1203&oldid=prev Connor: Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>CAST(expr AS type)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'..." 2012-07-13T11:53:55Z

<p>Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>CAST(expr AS type)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'..."</p> <p><b>New page</b></p><div><table align='right' border='1'><br /> <caption>Compatibility</caption><br /> <tr><th colspan='3'>CAST(expr AS type)</th></tr><br /> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr><br /> <tr><td align='left'>ingres</td><td>Yes</td><td></td></tr><br /> <tr><td align='left'>mysql</td><td>Yes</td><td></td></tr><br /> <tr><td align='left'>oracle</td><td>Yes</td><td></td></tr><br /> <tr><td align='left'>postgres</td><td>Yes</td><td></td></tr><br /> <tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr><br /> </table><br /> <h1>CAST</h1><br /> <p>CAST allows you to convert from one type to another. </p><br /> <p>Often a CAST is implicit - for example if you concatenate a string with a number the number will be automatically changed to a string. However sometimes you need to make the CAST explicit. </p><br /> <pre style='width:60ex'><br /> CAST(expr TO type) <br /> </pre><br /> <br /> <div class='qu'><br /> In this example we get the population in millions by casting the floating point value to DECIMAL(8,1) - this ensures one decimal place of accuracy.<br /> You can also CAST a date to a string to extract components using SUBSTRING or make up another date. <br /> <source lang='sql' class='def'><br /> SELECT CAST(population/1000000 AS DECIMAL(8,1)) AS a<br /> ,population/1000000 AS b<br /> FROM bbc<br /> </source><br /> </div><br /> <br /> <p>See also</p><br /> <ul><br /> <li>[[CONVERT function]]</li><br /> </ul></div>

Connor