How to insert dynamic table with time values?

[pirlo89]

Hello everyone, I have a question about inserting dynamic table with time values. Here is example of the table that I have to insert in db:

Schedule for 10/05/2016
	09:30 AM - 10:00 AM	Remove
	10:00 AM - 10:30 AM	Remove
	10:30 AM - 11:00 AM	Remove
	11:00 AM - 11:30 AM	Remove
	11:30 AM - 12:00 PM	Remove
	05:00 PM - 05:30 PM	Remove
	05:30 PM - 06:00 PM	Remove
	06:00 PM - 06:30 PM	Remove
	06:30 PM - 07:00 PM	Remove

I do not have a problem to insert values if my time difference in always the same. Like first few time slots are increased for 30 min but then I have a gap from 12:00pm all the way until 5:00pm. My problem is there. I do not know what is the best way to save these values. Since values are created dynamically and all of them are under the same date. If I do not have time breaks that would be really easy but in this case where I have time gap looks really complicated. If anyone can tell me what si the best way to store this in database please let me know. Thanks in advance.

[BKBK]

My suggestion is, don't save schedules in the database. Save the data in the two datetime columns startTime and endTime.

[pirlo89]

I have that already and is not what I need. Because if I just have stored start,end time and interval value I only can make equal time differences. What is I have 2 hours break in between time intervals?

[BKBK]

pirlo89 wrote:

Because if I just have stored start,end time and interval value I only can make equal time differences. What is I have 2 hours break in between time intervals?

I don't understand what you mean. In any case, here is a dynamic example:

<cfset t1=now()>

<cfset t1_meridiem = getMeridiem(t1)>

<cfset t2=dateadd("n",180,now())>

<cfset t2_meridiem = getMeridiem(t2)>

<!--- time in 12-hour format; note the lower-case letters --->

<cfoutput>#timeFormat(t1,"hh:mm")# #t1_meridiem#-#timeFormat(t2,"hh:mm")# #t2_meridiem#</cfoutput>

<cffunction name="getMeridiem">

    <cfargument name="t" default="#now()#" required="true" type="date">

     <!--- time in 24-hour format; note the capital letters --->

    <cfset var time24 = timeFormat(t,"HH:MM")>

    <cfset var hour24 = listFirst(time24, ":")>

    <cfif hour24 LTE 11>

        <cfreturn "AM">

    <cfelse>

        <cfreturn "PM">

    </cfif>

</cffunction>