Re: Timestamp

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