Moving dates between sql and dotNet

	declare @myDate datetime = getdate();
	select
	CurrentDateTime = @myDate,
	Formatted = CONVERT(varchar(8), @myDate, 112) + REPLACE(CONVERT(varchar(8), @myDate, 114),':','')
	/*
	.NET
	Parse in: DateTime.ParseExact()
	Write out: DateTime.ToString("yyyyMMddHHmmss")
	*/

view raw moving-dates-between-sql-dotNet.sql hosted with ❤ by GitHub