In modern software applications, time-stamped data is a common requirement. As a software developer or database administrator, you know that formatting dates is crucial for ensuring data accuracy and consistency. But with so many date formats and SQL engines out there, it can be challenging to find the right way to format dates for your specific needs.

SQL provides a date type that developers can use to store date values. Also, to make working with dates easier, SQL has several date functions for retrieving, formatting, and manipulating dates. In this post, you’ll learn about some SQL date functions and how to use them.

In today’s business landscape, predictive maintenance has emerged as a critical strategy to optimize equipment performance, reduce downtime, and minimize maintenance costs. In this article you will learn about some tools that can be used to simplify the complexity involved with implementing a successful predictive maintenance program.

Today we’re excited to announce the InfluxDB add-on for Ockam Orchestrator. Through the use of the add-on, customers that are using InfluxDB Cloud can use Ockam to improve their security posture by automatically granting uniquely identifiable, least privilege, time-limited credentials for any client that needs to connect to InfluxDB Cloud.

Data analysis is a crucial aspect of any business or organization because it helps with making informed decisions and improving overall performance. However, with the vast amounts of data generated every day, it can be overwhelming to manually analyze and derive insights from it.

This article was originally published on Medium.com and is reposted here with permission from the author. Trying to connect Grafana & InfluxDB IOx? Follow this tutorial to learn how.

Databases are often the biggest performance bottleneck in an application. They are also hard to migrate from once being used in production, so making the right choice for your application’s database is crucial. A big part of making the right decision is knowing what your options are. The database landscape has been changing rapidly in the past few years, so this article will try to simplify things for you by going over the following topics.

A look at how to use Flux for data cleansing and analytics through the browser and via Visual Studio. Time series data is data you want to analyze and monitor over time. For example, you might want to know the water levels over the course of the day for a plant, or how much sunlight it receives and when. This is a simple but easy-to-understand example. Obviously on a larger scale the stakes can be higher.

InfluxDB Cloud, powered by IOx, is a versatile time series database built on top of the Apache ecosystem. You can query InfluxDB Cloud with the Apache Arrow Flight SQL interface, which provides SQL support for working with time series data. In this tutorial, we will walk through the process of querying InfluxDB Cloud with Flight SQL, using Pandas and Jupyter Notebooks to explore and analyze the resulting data, and creating interactive plots and visualizations.

Manufacturing and industrial organizations are firmly in the era of Industry 4.0. The third wave of industrial revolution, which saw the introduction of computers, robots, and automation in industrial processes, has given way to instrumentation, and the use of advanced technologies, like machine learning (ML) and artificial intelligence (AI), using both raw and trained data, to enhance industrial processes.