Search code examples
azureazure-storageazure-table-storage

Using Timestamp as ModifiedDate in the Azure Table Storage

I was using the Timestamp column of an Azure Table as ModifiedDateTime for MyEntity, and locally it seems pretty cool.

But once on the server, is not really clear if the TimeStamp is in local server time or in the UTC... because apprears the question how to display that column to the users...

NB 1
I did some tests, and the timestamp seem to follow the current UTC time, but I am not sure is because of the rule, or because the server actual location is in same timezone as the UK's UTC...

NB 2
There was already a similar question in this thread... but I didn't find something in the azure documentation explicitly on the Timestamp.

Solution

  • The built-in Timestamp property is of type DateTime, which is UTC-based, and maintained by the storage service.

    You can see this defined here.