How to Filter by DateTime in Azure Table Storage

Still relevant since 2012: I’m glad you’re one of the thousands who find this post helpful. If you enjoy this article, I’d love for you to stick around and check out some of my more recent writing on technology, leadership, strategy, and AI. Explore recent posts →

Azure Table Storage provides a handy way to store data of all shapes and sizes. However, getting the data you want out of Table Storage can be a bit tricker than putting data in.

One filter I have found myself relying on over and over again during my time with Azure involves returning data for a particular date and time.

Timestamp gt datetime'2012-12-10T15:00:00'

Remember, data in the Timestamp column is stored in UTC so craft your WCF filters accordingly. ∎