Convert String to Datetime for SqlServer with C# [duplicate]

Question

Hello I have a String of this type: 20160104 I should convert it into format of SqlServer datetime with c#, how can I do? I have try with this:

DataUltimaVariazione = Convert.ToDateTime("20160104");

but visual studio give me an error

Where did this come from? Why is it a string instead of a DateTime value? If this came from a date or datetime column, retrieve it as DateTime, don't convert it to text — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Apr 25, 2016 at 13:04
you should work with SqlCommand class and Parameters. or you can use this: Date.ParseExact(dateString, "yyyyddMM", provider) — Sebastian Siemens
– Sebastian Siemens, Commented Apr 25, 2016 at 13:06
@SonerGönül this looks like the unseparated date format so this is unambiguously translated to yyyyMMdd in SQL Server. Mixing up this order would show an unusual temperament on the part of the file's author. Think Hannibal Lecter. Or that guy that types � in textboxes — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Apr 25, 2016 at 13:10

MusicLovingIndianGirl · Accepted Answer · 2016-04-25 13:05:13Z

6

Try

var myResultDate = DateTime.ParseExact("20160104", 
                                       "yyyyMMdd", 
                                       CultureInfo.InvariantCulture);

answered Apr 25, 2016 at 13:05

MusicLovingIndianGirl

5,9459 gold badges38 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Norman · Accepted Answer · 2016-04-25 13:11:48Z

2

You can use DateTime.ParseExact (https://msdn.microsoft.com/de-de/library/system.datetime.parseexact(v=vs.110).aspx) to convert a string to datetime:

DateTime dateTime = DateTime.ParseExact("20160104", "yyyyMMdd",
CultureInfo.InvariantCulture);

You could also use DateTime.TryParseExact (https://msdn.microsoft.com/de-de/library/h9b85w22(v=vs.110).aspx) which gives you more control on wrong formatted datetime strings:

DateTime dateTime;
if (DateTime.TryParse("20160104", "yyyyMMdd",
CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime))
{
    Console.WriteLine(dateTime);
}

edited Apr 25, 2016 at 13:11

answered Apr 25, 2016 at 13:06

Norman

3,5193 gold badges28 silver badges45 bronze badges

1 Comment

rikideveloper Over a year ago

thank you i have solve with this code

Collectives™ on Stack Overflow

Convert String to Datetime for SqlServer with C# [duplicate]

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related