When writing a SQL query, getting the date and time to format correctly can be a real pain. What is the current date and time, and how is it formatted? What happens if I want the date and time from 30 days ago? Is there a dashboard that demonstrates how to manipulate date and time for SQL Queries?
This SQL Page Timeframe dashboard demonstrates how the current date is picked up from the server hosting SquaredUp and how the Page Timeframe button impacts the date and time in a SQL query. Several different examples are demonstrated.
Each time on the dashboard does something different with the Date and Time. Here is how it breaks down:
Start now with hundreds of customizable dashboards.