Thread: dates

how do I convert a date from mm/dd/yyyy to dd/mm/yyyy

Thnaks

Peter

"peter" <peter@peter.com> writes:

> how do I convert a date from mm/dd/yyyy to dd/mm/yyyy

Dates are stored internally as a format-independent quantity.  To
format a date, use the to_char() function.  See the docs for
how to use to_char().

-Doug

On Friday 08 Nov 2002 12:02 am, peter wrote:
> how do I convert a date from mm/dd/yyyy to dd/mm/yyyy

Do you want to change the way dates are *displayed* or do you have dates in
the first format and want to *insert* them into the database.

For the first, see SET/SHOW DateStyle and for the second, I'd pre-parse them
in the application.

--
  Richard Huxton