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
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
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
It's working like this :
DATEADD(hour; 1; dbo.candidat_rendezvous.candidat_rendezvous_date)
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.