Convert String to Datetime for SqlServer with C#

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, Apr 25 '16 at 13:04
you should work with SqlCommand class and Parameters. or you can use this: `Date.ParseExact(dateString, "yyyyddMM", provider)` — Sebastian Siemens, Apr 25 '16 at 13:06
@rikideveloper you can parse the text to a DateTime value as shown in the answers, but why don't you use BCP, BULK INSERT or SSIS to import flat files ? — Panagiotis Kanavos, Apr 25 '16 at 13:08
@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, Apr 25 '16 at 13:10
try this var dateTime = new SqlDateTime(DateTime.ParseExact("20160104", "yyyyddMM", System.Globalization.CultureInfo.InvariantCulture)); — Ravindra Kumar Challagandla, Apr 25 '16 at 13:11

score 6 · Answer 1 · answered Apr 25 '16 at 13:05

6

Try

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

answered Apr 25 '16 at 13:05

MusicLovingIndianGirl

5,909
9
34
65

Norman · Answer 2 · 2016-04-25T13:11:48.200

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 '16 at 13:11

answered Apr 25 '16 at 13:06

Norman

3,279
3
25
42

thank you i have solve with this code – rikideveloper Apr 25 '16 at 13:11

Convert String to Datetime for SqlServer with C#

2 Answers2