Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
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
PrivateConstructorToCreateSingleObject
abdurrahimcan@gmail.com
asdxcscd
alop
a
Delegates, events
Fibonacci Series
MultiThreading and CancellationToken
Šovljanski - beskonačna petlja bez goto-a
jjj4