Ho to add 1 hour to my date

[grafic.web]

I need to add un hour to my date, how can i do???

This my code
CASE WHEN candidat_rendezvous_date IS NOT NULL THEN 'candidat_rendezvous_date + 1Hour' END

Thanks for your help

[cereal]

Hi, use dateadd():

dateadd(hour, 1, candidat_rendezvous_date)

• http://technet.microsoft.com/en-us/library/ms186819.aspx

[grafic.web]

I tryed this one , but i does not work :

CASE WHEN candidat_rendezvous_date IS NOT NULL THEN dateadd('hour. 1, candidat_rendezvous_date') END

[cereal]

Without the quotes and replace the dot with a comma, dateadd() takes three arguments the format, the integer to add and the date, currently it is like you are passing only the first argument because the quotes will submit it as a single string. So change it like this:

CASE WHEN candidat_rendezvous_date IS NOT NULL THEN dateadd(hour, 1, candidat_rendezvous_date) END

[grafic.web]

It's working like this :
DATEADD(hour; 1; dbo.candidat_rendezvous.candidat_rendezvous_date)

Thanks