Nitrates are not harmful to health. In our digestive system, they are converted into nitrite, which is harmful. How harmful nitrite is depends on the amount ingested. The World Health Organisation set a limit of 50 mg of nitrate per litre. This standard is adhered to by all drinking water companies.
Infants are more likely to convert nitrate into nitrite, which is why they are generally advised to drink bottled water.