In data Wed, 14 Feb 2001 21:10:30 +0000 (UTC), postgresql scrive:
>I have a table that has a 'date' column. In psql I tried to do a
>
>select proofdate::text from openjobs where jobno = '10625';
>
>responce: can not cast type 'date' to 'text'
>
>Did i miss-read this section. I thought I could cast the date to text. has anyone seen
>this or am I missreading the docs?
>
select to_char(proofdate, 'dd/mm/yyyy') from openjobs where jobno = '10625';