Check this out.... http://www.postgresql.org/docs/7.3/static/functions-formatting.html
to_char(departure, 'MM-DD-YYYY HH24:MI:SS') as newformatdeparture Ted --- Abdul Wahab Dahalan <[EMAIL PROTECTED]> 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 > > 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 __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
