date_format(ri.editDate,'%Y-%m-%d') as editDate
date_format(g.LoadDate,'%Y-%m-%d %H:%i:%s') as loadDate
DATE_FORMAT(NOW(),'%Y-%m-%d %H:%i:%s')
date_format(ri.editDate,'%Y-%m-%d') as editDate
date_format(g.LoadDate,'%Y-%m-%d %H:%i:%s') as loadDate
DATE_FORMAT(NOW(),'%Y-%m-%d %H:%i:%s')