sscasc@tumkur largest value+ decimal same as double but fixed point rather than floating point bit or date and time data types as with numberswe can choose from range of different data types to store dates and timesdepending on whether we want to store date onlya time onlyor bothdate/time data type description allowed range of values date date jan to dec datetime date and time midnight jan to : : dec timestamp timestamp : : jan to : : jan utc (universal coordinated timetime time : : to : : year year to string data types mysql allows storing text or binary strings of data in many different waysas shown in the following tablestring data type description allowed lengths charn fixed length string of characters characters varcharn variable length string of up to characters characters binaryn fixed length binary string of bytes bytes varbinarynvariable length binary string of up to bytes bytes mediumtext medium sized text field characters sp_python programming