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.

Improve this question

1 Answer 1

Reset to default
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
Improve this answer
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. Commented Feb 17, 2021 at 13:29

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.