If you mean that you have a CHAR or VARCHAR2 data type storing date values in the format dd.mm.yyyy then use TO_DATE to convert it to a DATE ... ... <看更多>

Below is a a query that will convert an Oracle date type to a iso8601-formatted string. I need an is8601 formatted date. SELECT sysdate, to_char ... ... <看更多>