SQL query


I have been working in Mode for some time and have only jus figured out hw to give me the monthly cumulative total as of today for a value. I asked for a little help from somewhere which works. But there is one string I dont understand. Please can someone explain this bit to me..


date_trunc('day', convert_timezone('UTC', a.timezone, oi.timestamp)) between date_trunc('month', convert_timezone('UTC', a.timezone, getdate())) and convert_timezone('UTC', a.timezone, getdate()) the_date,


I would like ot have this broken down and explained but cant figure it out. Any help is much appreciated.



Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 4 mths agoLast active
  • 44Views
  • 1 Following