Gerador de Matriz Data, C#

Gerador de Matriz Data

Language: Layout:

//Rextester.Program.Main is the entry point for your code. Don't change it.
//Compiler version 4.0.30319.17929 for Microsoft (R) .NET Framework 4.5

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text.RegularExpressions;

namespace Rextester
{
    public class Program
    {
        public static void Main(string[] args)
        {
            int quantidadeDias = 21;            
            Console.WriteLine("SELECT * FROM ( VALUES ");
            
            for(var i=0; i<quantidadeDias; i++)
            {
                var ini = DateTime.ParseExact("07-01-2020 00:00:00", "MM-dd-yyyy HH:mm:ss", null).AddDays(i);
                var fim = DateTime.ParseExact("07-01-2020 23:59:59", "MM-dd-yyyy HH:mm:ss", null).AddDays(i);
                
                Console.WriteLine("\t('{0}-{1}-{2} {3}:{4}:{5}'::timestamp, '{6}-{7}-{8} {9}:{10}:{11}'::timestamp){12}",
                                  ini.ToString("yyyy"),
                                  ini.ToString("MM"),
                                  ini.ToString("dd"),
                                  ini.ToString("HH"),
                                  ini.ToString("mm"),
                                  ini.ToString("ss"),

fim.ToString("yyyy"),
                                  fim.ToString("MM"),
                                  fim.ToString("dd"),
                                  fim.ToString("HH"),
                                  fim.ToString("mm"),
                                  fim.ToString("ss"),
                                  (i == quantidadeDias - 1) ? "" : ","
                                 );
            }
            
            Console.WriteLine(") datas (inicio, fim)");
        }
    }
}

Show compiler warnings [ + ] Show input
Compilation time: 0,26 sec, absolute running time: 0,11 sec, cpu time: 0,12 sec, average memory usage: 14 Mb, average nr of threads: 3, absolute service time: 0,42 sec

SELECT * FROM ( VALUES ('2020-07-01 00:00:00'::timestamp, '2020-07-01 23:59:59'::timestamp), ('2020-07-02 00:00:00'::timestamp, '2020-07-02 23:59:59'::timestamp), ('2020-07-03 00:00:00'::timestamp, '2020-07-03 23:59:59'::timestamp), ('2020-07-04 00:00:00'::timestamp, '2020-07-04 23:59:59'::timestamp), ('2020-07-05 00:00:00'::timestamp, '2020-07-05 23:59:59'::timestamp), ('2020-07-06 00:00:00'::timestamp, '2020-07-06 23:59:59'::timestamp), ('2020-07-07 00:00:00'::timestamp, '2020-07-07 23:59:59'::timestamp), ('2020-07-08 00:00:00'::timestamp, '2020-07-08 23:59:59'::timestamp), ('2020-07-09 00:00:00'::timestamp, '2020-07-09 23:59:59'::timestamp), ('2020-07-10 00:00:00'::timestamp, '2020-07-10 23:59:59'::timestamp), ('2020-07-11 00:00:00'::timestamp, '2020-07-11 23:59:59'::timestamp), ('2020-07-12 00:00:00'::timestamp, '2020-07-12 23:59:59'::timestamp), ('2020-07-13 00:00:00'::timestamp, '2020-07-13 23:59:59'::timestamp), ('2020-07-14 00:00:00'::timestamp, '2020-07-14 23:59:59'::timestamp), ('2020-07-15 00:00:00'::timestamp, '2020-07-15 23:59:59'::timestamp), ('2020-07-16 00:00:00'::timestamp, '2020-07-16 23:59:59'::timestamp), ('2020-07-17 00:00:00'::timestamp, '2020-07-17 23:59:59'::timestamp), ('2020-07-18 00:00:00'::timestamp, '2020-07-18 23:59:59'::timestamp), ('2020-07-19 00:00:00'::timestamp, '2020-07-19 23:59:59'::timestamp), ('2020-07-20 00:00:00'::timestamp, '2020-07-20 23:59:59'::timestamp), ('2020-07-21 00:00:00'::timestamp, '2020-07-21 23:59:59'::timestamp) ) datas (inicio, fim)