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 the Timestamp column is stored in UTC so craft your WCF filters accordingly.

If you found this helpful…

I’ve spent the last decade moving from hands-on engineering to executive leadership, and I write about that journey.

If data systems, cloud strategy, and systems design interest you, you might enjoy my writing on:

• The Auto Industry’s Cloud Awakening - Cloud data strategy
• The Simplicity Paradox - Designing simple, scalable systems
• Move Fast and Don’t Break Things - Building reliable data systems

Want insights on technology strategy and engineering leadership? Subscribe for updates →