Search code examples
azure-table-storageazure-storage

Azure Storage Explorer Query where by Timestamp

it's my first time working with Azure Storage Explorer and I need to read some logs that is save into Azure Tables. The version of mine is 4

I read this reference http://msdn.microsoft.com/library/azure/ff683669.aspx but there is not explanation to work with the column Timestamp.

Basically, I want to see logs since a specific date.

I tried query like;

Timestamp ge '4/10/2013' Timestamp ge 4/10/2013 Timestamp gt '4/10/2013'
Timestamp gt 4/10/2013

And the result is only a error message.

An error occurred while processing this request.

Solution

  • It looks like you would need to use something like below in order to filter on a Timestamp. Please look at Filtering on DateTime Properties here.

    Timestamp ge datetime'2008-07-10T00:00:00Z'