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.
It's a good practice to use appropriate data type for your data in sql. if your data is a date value. then you can use 'datetime' data type or 'smalldatetime'. This will also help you avoid future problems with data integrity.coz, sql will not allow non-date value in your data.f your data is a date value. then you can use 'datetime' data type or 'smalldatetime'. This will also help you avoid future problems with data integrity. coz, sql will not allow non-date value in your data.