What we can do with date and time offset data

9y873.NET

see here we store offset. so tell me what is the importance of storing offset data along with date and time ?

what we can do with offset data if we store ?

public void DemoDateTimeOffset()

{

DateTimeOffset offsetValue = new DateTime(2017, 1, 21, 4, 34, 0);

using (SqlConnection cn = new SqlConnection(myConnection))

{

string commandText = @" INSERT INTO DateTimeDemo (DateTimeExample,DateTimeOffsetExample)

VALUES (@DateTimeExample,@DateTimeOffsetExample)";

using (SqlCommand cmd = new SqlCommand(commandText, cn))

{

cmd.Parameters.AddWithValue("@DateTimeExample", DateTime.Now);

cmd.Parameters.AddWithValue("@DateTimeOffsetExample", offsetValue);

cn.Open();

cmd.ExecuteNonQuery();

}

thanks

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
Accepted answer
First of all, it is your database design so the person who designed the database table should be aware that why this date time offset is stored here.

Assuming that you don't have designed the table and you are curious why someone will store date off set values, I would answer here:

Date Time Offset uniquely and unambiguously identifies a date time value across the different time zones in the world.
It is used to represent the date and time while working in international environment.

In your case the first column is the local date time while the second is UTC (Coordinated Universal Time), in which -08:00 means this time is 8 hours behind the UTC.
+1
9y ago
thanks for reply.

when we store date time in utc format at server side by c# then date time does not look like 6/29/2011 4:52:48 PM UTC

so show me how could i convert client date time to utc format at server side by c# and again how we can convert UTC date time to client date time as per client timezone by js.

please come with code sample. thanks
0
Nilesh Shah9y ago
You are advised to do the conversion on client side, because your server may be hosted somewhere in different time zone and your user wants to see time as per his/her timezone.

pass your datetime to client side and using JS or jQuery do the conversion:
var date = new Date('6/29/2011 4:52:48 PM UTC');
date.toString() // "Wed Jun 29 2011 09:52:48 GMT-0700 (PDT)"
0
9y ago
if we know date time offset then how could i convert UTC date time to local date time.

if possible then please explain it with sample code. thanks
0