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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
