Skip to content

How to Filter by DateTime in Azure Table Storage

Robert Greiner
Robert Greiner

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.

Please consider subscribing, it's free.

Robert Greiner Twitter

Professional optimist. I write a weekly newsletter for humans at the intersection of business, technology, leadership, and career growth.