Robert Cain continues a series on KQL:
Reformatting dates is very common when querying data. You may, for example, wish to come up with a more compact date than the default KQL returns. Perhaps you work for an international company. In some countries you may want the date in month/day/year format, while other countries would prefer day/month/year.
Fortunately Kusto provides the
format_datetimefunction that allows you to do just this. We’ll take a look at it in this article.
Read on for a variety of examples.