SteveR,
A night rating is a JAA raiting, and goes onto your JAA licence. It is vaild in any JAR country.
I believe Spain is a JAR country.
Incidently it would also lift the day only limitation in the US as well. This is because the only thing stopping you flying at night in the US is the fact that your privilages are limited to those on your JAA licence.