How can I filter out a DATETIME field attribute by the hour? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

How can I filter out a DATETIME field attribute by the hour?

in Responsys 3 comments

I am trying to figure out how to create an audience filter based on our customer's coupon start time. Is there any way I can do this in Responsys? For example, I would like to create a filter that only includes users that have a start time between 10/28/2019 00:00:00 to 10/28/2019 00:59:59. From what I've seen, I can only do this by day and not hour.

Another solution I was considering is to create a SQL view that converts the datetime field to an integer field. However, I'm not sure if I can display the hour by doing this. Does anyone have any insight on how to go about this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!