Teru room

<h2 id="%E3%82%84%E3%82%8A%E3%81%9F%E3%81%84%E3%81%93%E3%81%A8">
<a class="header-anchor-link" href="#%E3%82%84%E3%82%8A%E3%81%9F%E3%81%84%E3%81%93%E3%81%A8" aria-hidden="true"></a> やりたいこと</h2>
<p>例えば Oracleの <strong>TO_CHAR()</strong> 関数でDATE型の値を任意の日本語の書式、例えば <strong>YY年MM月</strong> などに変換したいです。</p>
<h2 id="%E6%96%B9%E6%B3%95">
<a class="header-anchor-link" href="#%E6%96%B9%E6%B3%95" aria-hidden="true"></a> 方法</h2>
<p>場合には以下のように任意の日本語の書式部分の <strong>年</strong> と <strong>月</strong> を <strong>"</strong> で囲みます</p>
<div class="code-block-container">
<div class="code-block-filename-container"><span class="code-block-filename">NG：エラーになります</span></div>
<pre class="language-sql"><code class="language-sql">TO_CHAR<span class="token punctuation">(</span>HOGE_DATE<span class="token punctuation">,</span> <span class="token string">'YY年MM月DD日'</span><span class="token punctuation">)</span>
</code></pre>
</div><div class="code-block-container">
<div class="code-block-filename-container"><span class="code-block-filename">OK</span></div>
<pre class="language-sql"><code class="language-sql">TO_CHAR<span class="token punctuation">(</span>HOGE_DATE<span class="token punctuation">,</span> <span class="token string">'YY"年"MM"月"DD"日"'</span><span class="token punctuation">)</span>
</code></pre>
</div><p>もしも任意の書式を使っていなければエラーにはなりません</p>
<div class="code-block-container">
<div class="code-block-filename-container"><span class="code-block-filename">OK</span></div>
<pre class="language-sql"><code class="language-sql">TO_CHAR<span class="token punctuation">(</span>HOGE_DATE<span class="token punctuation">,</span> <span class="token string">'YY-MM-DD'</span><span class="token punctuation">)</span>
</code></pre>
</div>