How to format Date and Time on Windows Azure |
Phew, my first post about my journey on starting development on Windows Azure. I started a few weeks ago using the Mobile Services from Windows Azure, and I did learn a lot about it. This post is about formatting Date and Time strings, because Azure uses a different format than my Windows Phone app. If we upload a DateTime String to Windows Azure from a Windows Phone app, it looks like this: 2013-05-04T06:45:12.042+00:00 If we translate this, you have "YYYY-MM-DD" for the date. The letter "T" declares that the time string is starting now, formatted "HH:MM:ss.msmsms". The part "+00:00" is the timezone offset. So far, probably nothing new for you. Now let's get to Azure. Azure by standard uses the GMT time for Date strings (DateTime() in JavaScript = Date()). I have written a scheduler which fetches data from another web service and puts it into my table. Naturally, I wanted to know when the data were last checked, so I added a column for it. Then I did what everyone that is new to