Databases
StackOverflow2013
Postsdbo
POSpecify timezone of datetime without changing value
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSpecify timezone of datetime without changing value
    primarykey
    data
    text
    <p>I'm wondering how to go about changing the timezone of a DateTime object without actually changing the value. Here is the background...</p> <p>I have an ASP.NET MVC site hosted on AppHarbor and the server has its time set to UTC. When I submit a form from my site containing a datetime value, say 9/17/2013 4:00am, it comes up to the server with that value. However then when I do:</p> <pre><code>public ActionResult Save(Entity entity) { entity.Date = entity.Date.ToUniversalTime(); EntityService.Save(entity); } </code></pre> <p>...it incorrectly keeps it as the same time (4am) because the server is already on UTC time. So after converting to UTC and saving to the database, the database value is 2013-09-17 04:00:00.000, when really it should be 2013-09-17 08:00:00.000, as the browser is on EST. I was hoping after form submission and passing the values to the controller action, it would set the DateTime's timezone to the browser's (EST) rather than the server host's (UTC), however that didn't happen.</p> <p>In any case, now I'm stuck with a DateTime object that contains the correct date/time value but the wrong time zone, so I can't correctly convert it to UTC. I store the time zone of each user, so if there was a way to set the time zone for the DateTime object without actually changing the value (I can't do TimeZoneInfo.ConvertTime because it'll change the value) then I could have the correct date/time value AND the correct time zone, then I could safely do date.ToUniversalTime. That being said, I've only seen how to change the KIND of a DateTime, not the TimeZone, without changing its actual value.</p> <p>Any ideas?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USJustin
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSpecify timezone of datetime without changing value
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSpecify timezone of datetime without changing value
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCheck out this answer: http://stackoverflow.com/questions/6682290/c-sharp-datetimes-conversion-for-different-time-zones
      singulars
      1. POSpecify timezone of datetime without changing value
      1. USaleciten
    2. COYou can try to convert client date value like Date('yourdatehere').toISOString()
      singulars
      1. POSpecify timezone of datetime without changing value
      1. USFrank59
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload