title: Date to String format in Firebird
body: <p>How can I customize CAST (TimeStamp TO STRING) format in Firebird?</p>
  
  <pre><code>cast (&lt;DateField&gt; as VarChar(25))
  </code></pre>
  
  <p>It does not work as I want.</p>
  
  <p>I do as I wish with the EXTRACT function</p>
  
  <pre><code>EXTRACT(day FROM &lt;DateField&gt;) || '.' || EXTRACT(month FROM &lt;DateField&gt;)||
  '.' || EXTRACT(year FROM &lt;DateField&gt;) || ' ' || EXTRACT(hour FROM &lt;DateField&gt;)
  </code></pre>
  
  <p>Is there a more practical way, such as MS-SQL Server:</p>
  
  <pre><code>convert(nvarchar(MAX), @now, 108)
  </code></pre>