karuispirit
6 years agoLevel 1
SQL Query for Calendar Schedule
Hi all,
I'm trying to get this to display in a readable format. Is it possible to format the 'days', 'specificExcludeDates', and 'specificIncludeDates'.
SQL Query:
SELECT
domain_ScheduleCalendar.policyname,
domain_ScheduleCalendar.days,
domain_ScheduleCalendar.specificexcludedates,
domain_ScheduleCalendar.specificincludedates
FROM
domain_ScheduleCalendar
What I see:
policyname | days | specificexcludedates | specificincludedates |
test_b1 | 00000010000001000000100000010000000 | 133233300000000000;133262676000000000;133286868000000000; | 134181972000000000;134496468000000000;134810964000000000;135125460000000000;135446004000000000; |
I want to see them in a readable format.
Thank you in advance!