http://www.sqlzoo.net/w/index.php?title=TO_CHAR(dates)&feed=atom&action=history
TO CHAR(dates) - Revision history
2013-06-18T06:39:58Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://www.sqlzoo.net/w/index.php?title=TO_CHAR(dates)&diff=1400&oldid=prev
Connor at 15:28, 16 July 2012
2012-07-16T15:28:33Z
<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 15:28, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 44:</td>
<td colspan="2" class="diff-lineno">Line 44:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[EXTRACT |EXTRACT function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[EXTRACT |EXTRACT function]]</li></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[[ +(date) function]]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[[<ins class="diffchange diffchange-inline">%2B(dates) |</ins>+(date) function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[HOUR |HOUR function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[HOUR |HOUR function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[MINUTE |MINUTE function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[MINUTE |MINUTE function]]</li></div></td></tr>
</table>
Connor
http://www.sqlzoo.net/w/index.php?title=TO_CHAR(dates)&diff=1333&oldid=prev
Connor at 14:02, 16 July 2012
2012-07-16T14:02:08Z
<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:02, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 25:</td>
<td colspan="2" class="diff-lineno">Line 25:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT DATEPART(YEAR from whn) AS v</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT DATEPART(YEAR from whn) AS v</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;">  AND DATEPART(MONTH from whn) AS w</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       ,whn</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       ,whn</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       ,wht</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       ,wht</div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 37:</td>
<td colspan="2" class="diff-lineno">Line 36:</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><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 EXTRACT(YEAR from whn) AS v,</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>SELECT EXTRACT(YEAR from whn) AS v, whn, wht</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">  AND EXTRACT(MONTH from whn) AS w </del>whn, wht</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM eclipse</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM eclipse</div></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>
</table>
Connor
http://www.sqlzoo.net/w/index.php?title=TO_CHAR(dates)&diff=1332&oldid=prev
Connor: Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>TO_CHAR(d,'YYYY')</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>''..."
2012-07-16T14:01:26Z
<p>Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>TO_CHAR(d,'YYYY')</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'>TO_CHAR(d,'YYYY')</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>No</td><td>[[EXTRACT |EXTRACT(HOUR from d)]]</td></tr><br />
<tr><td align='left'>mysql</td><td>No</td><td>[[EXTRACT |EXTRACT(HOUR from d)]]</td></tr><br />
<tr><td align='left'>oracle</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>postgres</td><td>No</td><td>[[EXTRACT |EXTRACT(HOUR from d)]]</td></tr><br />
<tr><td align='left'>sqlserver</td><td>No</td><td>[[DATEPART |DATEPART(HOUR,d)]]</td></tr><br />
</table><br />
<h1>TO_CHAR (dates)</h1><br />
<p>TO_CHAR allows you to convert a date to a string using a variety of formats. </p><br />
<p></p> <br />
<pre style='width:60ex'><br />
TO_CHAR(d, 'YYYY') -> Four digit year<br />
TO_CHAR(d, 'MM') -> Two digit month<br />
TO_CHAR(d, 'DD') -> Two digit day<br />
TO_CHAR(d, 'HH24') -> Two digit hour<br />
TO_CHAR(d, 'MI') -> Two digit minutes<br />
TO_CHAR(d, 'MON') -> Three character month<br />
</pre><br />
<br />
<div class='ht'><br />
In this example you get the month as a three character abbreviation and a four digit year from the date field whn. <br />
<source lang='sql' class='def e-sqlserver'><br />
SELECT DATEPART(YEAR from whn) AS v<br />
AND DATEPART(MONTH from whn) AS w<br />
,whn<br />
,wht<br />
FROM eclipse<br />
</source><br />
<source lang='sql' class='def e-oracle'><br />
SELECT TO_CHAR(whn, 'MON YYYY') AS v<br />
,whn<br />
,wht<br />
FROM gisq.eclipse<br />
</source><br />
<source lang='sql' class='def'><br />
SELECT EXTRACT(YEAR from whn) AS v,<br />
AND EXTRACT(MONTH from whn) AS w whn, wht<br />
FROM eclipse<br />
</source><br />
</div><br />
<br />
<p>See also</p><br />
<ul><br />
<li>[[EXTRACT |EXTRACT function]]</li><br />
<li>[[ +(date) function]]</li><br />
<li>[[HOUR |HOUR function]]</li><br />
<li>[[MINUTE |MINUTE function]]</li><br />
<li>[[DAY |DAY function]]</li><br />
<li>[[MONTH |MONTH function]]</li><br />
<li>[[SECOND |SECOND function]]</li><br />
</ul></div>
Connor