Create Table Using The Datestamp

How to create a table using current date stamp? I want the format of date stamp to be MM/DD/YYYY Let's say I want to use that format: what is the exact code for that? Instead of

Solution 1:

Instead of table, i want to use that datestamp to be my database_name?

Never a good idea to put data of high volatility as a database name. (You do not want a brand new database for every day of every year).

You can add one column to your table(s), and it must be TEXT, INTEGER, or REAL.

If using TEXT, only certain formats work correctly. MM/DD/YYYY is not one of those formats because 06/12/1945 would be before07/05/2014