View ocum.volumetransferrateweeklyview | Generated by SchemaSpy |
View Definition:
select round((sum(`volumedatatransferstatusview`.`transferSize`) / 1024),3) AS `totalTransferSize`,date_format(`volumedatatransferstatusview`.`transferEndTime`,'%Y-%m-%d %H:00:00') AS `endTime`,dayname(cast(`volumedatatransferstatusview`.`transferEndTime` as date)) AS `day` from `ocum`.`volumedatatransferstatusview` where ((cast(`volumedatatransferstatusview`.`transferEndTime` as date) >= (curdate() - interval 7 day)) and (cast(`volumedatatransferstatusview`.`transferEndTime` as date) < curdate())) group by date_format(date_format(`volumedatatransferstatusview`.`transferEndTime`,'%Y-%m-%d %H:00:00'),'%H:00:00'),weekday(date_format(`volumedatatransferstatusview`.`transferEndTime`,'%Y-%m-%d %H:00:00')),cast(date_format(`volumedatatransferstatusview`.`transferEndTime`,'%Y-%m-%d %H:00:00') as date),dayname(cast(date_format(`volumedatatransferstatusview`.`transferEndTime`,'%Y-%m-%d %H:00:00') as date)) order by `endTime`
Possibly Referenced Tables/Views: