Re: Timestamp
От
Tomasz Myrta
Тема
Re: Timestamp
Дата
Msg-id
3F963D41.3000307@klaster.net
Ответ на
Timestamp (Abdul Wahab Dahalan)
Список
Дерево обсуждения
Timestamp Abdul Wahab Dahalan <wahab@mimos.my>
Re: Timestamp Theodore Petrosky <tedpet5@yahoo.com>
Re: Timestamp Tomasz Myrta <jasiek@klaster.net>
Re: Timestamp achill@matrix.gatewaynet.com
Dnia 2003-10-22 10:02, Użytkownik Abdul Wahab Dahalan napisał: > Hi ! > In my database I've a field "departure" with timestamp without time zone > data type. > eg : > departure > 2003-11-01 14:29:46 > > Now I want to select it as in this format 01-11-2003 14:29:46 How should > I do it?. You can find it in documentation - 6.7. Data Type Formatting Functions select to_char(departure,'DD-MM-YYYY HH24:MI:SS') ... Regards, Tomasz Myrta
В списке pgsql-sql по дате отправления
