On Wed, 22 Oct 2003, Abdul Wahab Dahalan wrote:
> Hi !
> In my database I've a field "departure" with timestamp without time zone
> data type.
> eg :
> departure
> 2003-11-01 14:29:46
Maybe
SET DateStyle TO 'German' ;
SELECT replace(departure,'.','-') from <yourtable> ;
is close to what you want,
but better leave it default and format the date (input/output) from your
app.
>
> Now I want to select it as in this format 01-11-2003 14:29:46 How should
> I do it?.
>
> Thank you for any help.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
-Achilleus