From:http://www.2cto.com/database/201303/195083.html
MySQL date and character are converted Date_format (date, '%y-%m-%d ')--------------To_char () in >oracle; Str_to_date (date, '%y-%m-%d ')--------------to_date () in >oracle; Www.2cto.com%Y: Represents a 4-digit year%Y: Represents the year of 2 for%m: Represents the month, in the format (01 ... %c: Represents the month in the format (1 ...). %d: Represents the number of days in the month in the format (00 ...). %e: Represents the number of days in the month, in the format (0 ...). %H: Represents the hour, in the form of (00 ... %k: Represents the hour in the format of (0 ...). %h: Represents the hour in the format of (01 ...). %I: Represents the hour, in the format (01 ...). %l: Represents the hour, in the format (1 ...). %i: Represents minutes in the format of (00 ... %r: Represents the time, in the format of 12 hours (Hh:mm:ss [ap]m)%T: Represents the time, in the format of 24 hours (HH:MM:SS)
MySQL date and characters convert each other