Get the names of tables created on a specific date

Question

I need to know the names of the tables that were created on a specific date.

I am using SQL Server 2012.

Is there any query I can use?

Answer 1

One way is to query sys.tables:

SELECT name
FROM sys.tables
WHERE CONVERT(date, create_date) = 'YYYYMMDD'

Create_date is a datetime so you probably want to convert it.