breezejs: date is not set to the right time

by

Breeze does not manipulate the datetimes going to and from the server in any way EXCEPT to add a UTZ timezone specifier to any dates returned from the server that do not already have one. This is only done because different browsers interpret dates without a timezone specifier differently and we want consistency between browsers.

The source of your issues is likely to be that when you save your data with dates to the database, that the dateTime datatype you are using does NOT contain a timezone offset. This means that when the data is retrieved you are likely “losing” the offset and the Breeze default mentioned above kicks in. This can be corrected by using a database date time datatype with an timezone offset ( datetime2 or datetimeoffset in SQLServer).

Note that your browser DOES format dates according to it’s current timezone.

Another approach is that you can replace Breeze’s DataType.parseDateFromServer to NOT infer any time zone info if it is not provided:

breeze.DataType.parseDateFromServer = function (source) {
     return new Date(Date.parse(source));
};

However, this can run into the problem that different browsers interpret DateTime strings without a time zone offset differently… So you may still get strange results depending on the browser. If that happens you will need to add some browser detection code to the snippet above.

Another alternative is to do the following using the moment.js library. 

breeze.DataType.parseDateFromServer = function (source) {
     var date = moment(source); 
     return date.toDate();   
};

Not sure how helpful this is, but hopefully Breeze’s behavior is clearer.

More Related Contents:

  1. Change date format as dd/mm/yyyy in php [closed]
  2. How can I parse / create a date time stamp formatted with fractional seconds UTC timezone (ISO 8601, RFC 3339) in Swift?
  3. Parsing RFC-3339 / ISO-8601 date-time string in Go
  4. `uuuu` versus `yyyy` in `DateTimeFormatter` formatting pattern codes in Java?
  5. group by dates in mongodb
  6. Format date as dd/MM/yyyy using pipes
  7. How to convert milliseconds into human readable form?
  8. Zero-based month numbering [closed]
  9. Is it always a good idea to store time in UTC or is this the case where storing in local time is better?
  10. Date does not display from Model on HTML input type date
  11. How to convert ISO Date to UTC date in Hive
  12. VBScript How can I Format Date?
  13. Google Apps Script date format issue (Utilities.formatDate)
  14. Determine season given timestamp in Python using datetime
  15. Difference between two dates expressed as years, months, days (in one column)
  16. How to compare dates or date against today with query on google sheets?
  17. Date arithmetic in cmd scripting
  18. Changing date format to “%d/%m/%Y”
  19. Compare two dates Google apps script
  20. How do I align date and values to gridlines in Google Chart?
  21. Carbon Difference in Time between two Dates in hh:mm:ss format
  22. Same date in different time zone
  23. What is the precise definition of JDE’s Julian Date format?
  24. How to prevent ifelse() from turning Date objects into numeric objects
  25. Why is the Java date API (java.util.Date, .Calendar) such a mess?
  26. NSDate() or Date() shows the wrong time
  27. new Date() is working in Chrome but not Firefox
  28. Java getHours(), getMinutes() and getSeconds()
  29. How to get the week day name from a date?
  30. Round a POSIX date (POSIXct) with base R functionality

Leave a Comment