Gerador de Matriz Data, C#

Gerador de Matriz Data

//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)");
        }
    }
}


run \| edit \| history \| help	0

λ

                                      .NET NoSQL database for rapid development