This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Amazon suggests storing dates in ISO 8601 format: 2008-01-24T13:15:30.45+01:00 We see dates being stored in the following format which is missing the fraction of a second component and the timezone: 2009-04-27T17:20:57 Is there anyway for Lightspeed to store dates in ISO 8601 format so the fraction of a second and timezone are preserved? DateTime.ToString("yyyy-MM-ddTHH:mm:ss.fffzzzz")? |
|
|
We can implement that for you, but I'm not convinced that including the time zone is a wise move. Because Amazon does lexical sorting, a time of 2008-01-01T12:00:00.00+03:00 (3 pm) would sort *earlier* than 2008-01-01T13:00:00+01:00 (1pm). So my inclination would be to add fractions of a second if you need them, but to leave off the time zone. Open to discussion on this one! (Unfortunately we don't currently have a means of leaving the formatting decision up to the application -- I realise this is something we probably need to look into but that's a more substantive change.) |
|
|
For us, the timezone will always be a constant. Leaving it off isn't a problem (yet).
If you could add fractions of a second in there, josefresno and I would appreciate it. We have a scenario where we need that.
|
|
|
Okay, I've committed a change to save fractions of a second (down to millisecond resolution), and it will be in the 29 Apr 2009 nightly build. Please let us know if you run into any problems. |
|