I donwload skillbuilder plug-in calendar from
I followed the instruction to add a column from table as title shown in my calendar.
SELECT NULL AS id, title AS title, 'false' AS all_day, TO_CHAR(start_date, 'YYYY-MM-DD"T"HH24:MI:SS') AS start_date, NULL AS end_date, NULL AS url, NULL AS class_name FROM events
However, I don't know why there is a "12a" in front of the title in my calendar? I have gone through the SQL but I still couldn't figure it out. I will appreciate if you can shed some lights on me.
That's the time. 12a = 12 a.m. = 12:00 in the morning
I don't think the SkillBuilders version allows you to adjust the time format. I'll look into that with the Enkitec version I'm currently working on.