1

I have a use case where I want to use the "Wait by Attribute" function in Journey Builder to wait until a specific time of day to send and I need to figure out the SQL to change just the hour and minute portions of the attribute field to be the time of day I want to send while keeping the day, month, year the same.

1

Figured it out using the DATEADD function to add a fractional day to the date.

DATEADD(DAY, DATEDIFF(DAY, 0, LOAD_DATE), 0.625) AS SEND
1
  • 3
    DateAdd() also allows you to add hours (hour, hh) minutes (minute, mi) seconds (second,ss,s) and milliseconds (millisecond,ms). This is not to say your fractional day is not a solution, just that there may be a more 'readable' solution through one of these. Feb 17 at 13:29

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.