March 6 Pisces birthdate individuals will kill you with kindness. You are sympathetic and pleasing. If you are down in the dumps, leave it to a Piscean to cheer you up. If today is your birthday you will make everyone feel special and your friends or family members can count on you in times of crisis.
Introduction to MySQL DATE_FORMAT function. To format a date value to a specific format, you use the DATE_FORMAT function. format : is a format string that consists of predefined specifiers. Each specifier is preceded by a percentage character ( % ). See the table below for a list of predefined specifiers.
Therefore, when you issue the query select b from x; you will see something like: B --------- 01-APR-98 Whenever a DATE value is displayed, Oracle will call TO_CHAR automatically with the default DATE format. However, you may override the default behavior by calling TO_CHAR explicitly with your own DATE format.