Convert hex value from SQL Server to datetime in C#

Question

I need to convert 8 bytes from a hexadecimal value to a new datetime in C#. The function should do the same as it does in SQL Server.

I have the hexadecimal value as a string "0000AC0500000000" or a list of bytes:

["0", "0", "172", "5", "0", "0", "0", " 0 ",]

From that I need to obtain the date "2020-07-27 00:00:00:000". The convert of the SQL Server works perfectly to recover up to milliseconds with only 8 bytes. As shown convert function in SQL Server

Curious. Why do you have it in this form in the first place? — Matt Johnson-Pint
– Matt Johnson-Pint, Commented Sep 17, 2020 at 18:24
Like @Matt, I have some real questions here - mostly "what was wrong with the SQL server date/time types?" — Marc Gravell
– Marc Gravell, Commented Sep 17, 2020 at 19:10

jdweng · Accepted Answer · 2020-09-17 17:56:43Z

1

Use following

            string input = "0000AC0500000000";

            int daysFrom1900 = int.Parse(input.Substring(0,8),NumberStyles.HexNumber);
            int ticksFromMidnight = int.Parse(input.Substring(8), NumberStyles.HexNumber);
            DateTime year1900 = new DateTime(1900, 1, 1);
            DateTime date = year1900.AddDays(daysFrom1900).AddTicks(ticksFromMidnight*(10/3.0));

edited Sep 17, 2020 at 17:56

answered Sep 17, 2020 at 16:52

jdweng

34.5k3 gold badges17 silver badges19 bronze badges

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

1 Comment

hikoruKazuto Over a year ago

this is correct, but to add the milliseconds it must be done like this (sql server): DateTime date = year1900.AddDays(daysFrom1900).AddTicks(ticksFromMidnight*(10/3.0));

Collectives™ on Stack Overflow

Convert hex value from SQL Server to datetime in C#

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related