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
1
  • what about a formula field with the calculation and query the formula field instead? Commented May 5, 2020 at 13:10

1 Answer 1

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .