You want to take a look at the to_char function described here: http://www.postgresql.org/devel-corner/docs/user/functions-formatting.html in your case it would be: SELECT to_char(myDateField, 'DD-MM-YYYY') Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio On Fri, 23 Mar 2001, Naomi Fullam wrote: > Hi > I found this function for mysql > > SELECT DATE_FORMAT(myDateField, '%d-%m-%Y') FROM myTable > > The DATE_FORMAT function allows one to format myDateField as I see fit, > I want to have it in date-month-year format. myDateField is of type > date. > > Basically I was just wondering if there is a similar Postgres command? > > Thanks in advance! > > Naomi > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
