Azure Storage Explorer Query where by Timestamp

CidaoPapito picture CidaoPapito · Apr 23, 2014 · Viewed 18.6k times · Source

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.

Answer

Veena Udayabhanu - MSFT picture Veena Udayabhanu - MSFT · Apr 24, 2014

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'