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