How to find the list of compelete date from first entry of the date in sql databse

hello i am new in yii2 i want to solve a query in my project .
i enter the date in database and know i want the complete list of the date from the first entry of the date in database how can i get this using yii2 sql query .If you have a solution then please give me .