Dashboard Fridays: Sample SQL Page Timeframe dashboard
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? 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.