formating a select from a timestamp column

Поиск
Список
Период
Сортировка
hi i have a column that is declared as:
datum timestamp DEFAULT ('now'::text)::timestamp(6) with time zone


then i do:
SELECT datum from table;
and get something like: 2005-11-13 00:00:00

i would like the output to be on the format: 2005-11-13
how can i change it?

i use postgresql 8.1

thanks
stig

В списке pgsql-novice по дате отправления: