View ocum_report.volumerelationshiphistoryaggweekhourview | Generated by SchemaSpy |
View Definition:
select sum(`volumerelationshiphistoryview`.`transferSize`) AS `aggTransferSize`,date_format(`volumerelationshiphistoryview`.`endTime`,'%H:00:00') AS `endTime`,weekday(`volumerelationshiphistoryview`.`endTime`) AS `dayCount`,cast(`volumerelationshiphistoryview`.`endTime` as date) AS `endDate`,dayname(cast(`volumerelationshiphistoryview`.`endTime` as date)) AS `day` from `ocum_report`.`volumerelationshiphistoryview` where ((cast(`volumerelationshiphistoryview`.`endTime` as date) >= (curdate() - interval 7 day)) and (cast(`volumerelationshiphistoryview`.`endTime` as date) < curdate())) group by date_format(`volumerelationshiphistoryview`.`endTime`,'%H:00:00'),weekday(`volumerelationshiphistoryview`.`endTime`),cast(`volumerelationshiphistoryview`.`endTime` as date),dayname(cast(`volumerelationshiphistoryview`.`endTime` as date)) order by date_format(`volumerelationshiphistoryview`.`endTime`,'%H:00:00')
Possibly Referenced Tables/Views: