How to add only date like 'DD/MM/YYYY' to timestamp in PostgreSQL?
<p>I'm trying to add only the current date in "DD/MM/YYYY" format in a field of type ' timestamp in PostgreSQL' .</p>

<p>I try:</p>

<pre><code>select to_char(now(),'DD/MM/YYYY') as date;
</code></pre>

<p>But PostgreSQL return me:</p>

<p>TIP : You will need to rewrite the expression or apply a type conversion.</p>