Best way to display date and time in a table with massive amounts of data?

1. How to create a DOB table in SQL?
2. How to set date format while creating table in MySQL?

How to create a DOB table in SQL?

You don't need to specify the format in the table definition as dates are stored in a binary format. CREATE TABLE APP( ID INT NOT NULL, DT DATE, ADDRESS NVARCHAR (100) , PRIMARY KEY (ID) ); When you try to insert into that table however, the server will try to convert the string to a date before inserting it.

How to set date format while creating table in MySQL?

MySQL uses yyyy-mm-dd format for storing a date value. This format is fixed and it is not possible to change it. For example, you may prefer to use mm-dd-yyyy format but you can't. Instead, you follow the standard date format and use the DATE_FORMAT function to format the date the way you want.