0

I want to add 7 hours to a timestamp value and write the value into another data extension. How can I add these hours?

My poor first try:

SELECT
DATEADD(HOUR,+7,dateregister) AS dateregister_new_time 
FROM
customer
  • what about a formula field with the calculation and query the formula field instead? – Sergio Alcocer May 5 at 13:10
0

You are in right direction. Please use the below SQL query.

SELECT
DATEADD(hh, 7, dateregister) as dateregister_new_time 
FROM
customer

Let me know if this helps

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.