We have a date/time field that I'd like to accomplish the following with:
- Split the date and time into two separate columns (while also maintaining the original column)
- Round the time down to the nearest half hour increment (for instance, 8:43 would round to 8:30, 8:18 would round to 8:00, etc.)
Issues to be considered: the date and timestamp isn't in a standard format - so text functions like pad, trim, etc. won't necessarily work. For instance, we have values such as:
- 8/19/2019 4:38:51 AM
- 8/19/2019 10:04:42 PM
- 8/8/2019 8:30:00 AM
- 12/5/2019 9:14:12 PM
Anybody have any ideas on how to accomplish this?
Thanks!