Re: Convert TimeStamp to Date - Mailing list pgsql-general

Ron Johnson wrote:

>tree=# select date('1993-08-10 17:48:41.074');
>    date
>------------
> 10-08-1993
>(1 row)
>
>
>
This *does* work on 7.3 (I suppose, because it ends up converting *text*
to date, not *timestamp*, and it is timestamp conversion, that's broken):

testdb=# select date('1993-08-10 17:48:41.074'::timestamp);
    date
------------
 1993-08-11
(1 row)


Dima