2
    
  

 <style>


	table.cfdump_wddx,
	table.cfdump_xml,
	table.cfdump_struct,
	table.cfdump_varundefined,
	table.cfdump_array,
	table.cfdump_query,
	table.cfdump_cfc,
	table.cfdump_object,
	table.cfdump_binary,
	table.cfdump_udf,
	table.cfdump_udfbody,
	table.cfdump_udfarguments {
		font-size: xx-small;
		font-family: verdana, arial, helvetica, sans-serif;
		cell-spacing: 2px;
	}

	table.cfdump_wddx th,
	table.cfdump_xml th,
	table.cfdump_struct th,
	table.cfdump_varundefined th,
	table.cfdump_array th,
	table.cfdump_query th,
	table.cfdump_cfc th,
	table.cfdump_object th,
	table.cfdump_binary th,
	table.cfdump_udf th,
	table.cfdump_udfbody th,
	table.cfdump_udfarguments th {
		text-align: left;
		color: white;
		padding: 5px;
	}

	table.cfdump_wddx td,
	table.cfdump_xml td,
	table.cfdump_struct td,
	table.cfdump_varundefined  td,
	table.cfdump_array td,
	table.cfdump_query td,
	table.cfdump_cfc td,
	table.cfdump_object td,
	table.cfdump_binary td,
	table.cfdump_udf td,
	table.cfdump_udfbody td,
	table.cfdump_udfarguments td {
		padding: 3px;
		background-color: #ffffff;
		vertical-align : top;
	}

	table.cfdump_wddx {
		background-color: #000000;
	}
	table.cfdump_wddx th.wddx {
		background-color: #444444;
	}


	table.cfdump_xml {
		background-color: #888888;
	}
	table.cfdump_xml th.xml {
		background-color: #aaaaaa;
	}
	table.cfdump_xml td.xml {
		background-color: #dddddd;
	}

	table.cfdump_struct {
		background-color: #0000cc ;
	}
	table.cfdump_struct th.struct {
		background-color: #4444cc ;
	}
	table.cfdump_struct td.struct {
		background-color: #ccddff;
	}

	table.cfdump_varundefined {
		background-color: #CC3300 ;
	}
	table.cfdump_varundefined th.varundefined {
		background-color: #CC3300 ;
	}
	table.cfdump_varundefined td.varundefined {
		background-color: #ccddff;
	}

	table.cfdump_array {
		background-color: #006600 ;
	}
	table.cfdump_array th.array {
		background-color: #009900 ;
	}
	table.cfdump_array td.array {
		background-color: #ccffcc ;
	}

	table.cfdump_query {
		background-color: #884488 ;
	}
	table.cfdump_query th.query {
		background-color: #aa66aa ;
	}
	table.cfdump_query td.query {
		background-color: #ffddff ;
	}


	table.cfdump_cfc {
		background-color: #ff0000;
	}
	table.cfdump_cfc th.cfc{
		background-color: #ff4444;
	}
	table.cfdump_cfc td.cfc {
		background-color: #ffcccc;
	}


	table.cfdump_object {
		background-color : #ff0000;
	}
	table.cfdump_object th.object{
		background-color: #ff4444;
	}

	table.cfdump_binary {
		background-color : #eebb00;
	}
	table.cfdump_binary th.binary {
		background-color: #ffcc44;
	}
	table.cfdump_binary td {
		font-size: x-small;
	}
	table.cfdump_udf {
		background-color: #aa4400;
	}
	table.cfdump_udf th.udf {
		background-color: #cc6600;
	}
	table.cfdump_udfarguments {
		background-color: #dddddd;
		cell-spacing: 3;
	}
	table.cfdump_udfarguments th {
		background-color: #eeeeee;
		color: #000000;
	}

</style> 
		
		<table class="cfdump_query">
			<tr>
			
			
			<th class="query" colspan="2">query</th>
			</tr>
			<tr  class="query" valign="top">
				<td class="query"  onClick="cfdump_toggleRow_qry(this);">RESULTSET</td>
				<td>
				<table class="cfdump_query">
				<tr>
			
				<th class="query" colspan="10">query</th>
				</tr>
			
				<tr bgcolor="eeaaaa" >
				<td class="query"  onClick="cfdump_toggleRow_qry(this);">&nbsp;</td>
				
				<td class="query">ENDTIME</td>
				
				<td class="query">EVENTDATE</td>
				
				<td class="query">EVENTDURATION</td>
				
				<td class="query">EVENTID</td>
				
				<td class="query">EVENTTITLE</td>
				
				<td class="query">LOCATIONNAME</td>
				
				<td class="query">SHORTDESCRIPTION</td>
				
				<td class="query">STARTTIME</td>
				
				<td class="query">TIMEZONE</td>
				
				</tr>
				
				
				<tr >
				<td  onClick="cfdump_toggleRow_qry(this);" class="query">1</td>
				
				
					<td valign="top">
			3:00 PM
		</td>
				
					<td valign="top">
			2009-03-20 00:00:00.0
		</td>
				
					<td valign="top">
			[empty string]
		</td>
				
					<td valign="top">
			215410
		</td>
				
					<td valign="top">
			Southern California- Cardio Tennis Workshop USPTA
		</td>
				
					<td valign="top">
			Pacific Tennis Club
		</td>
				
					<td valign="top">
			Southern California-CTW
		</td>
				
					<td valign="top">
			10:00 AM
		</td>
				
					<td valign="top">
			EST
		</td>
				
				</tr>
				
			


			
			
				</table>
				</td>
			</tr>
			
			
				
					
					
						<tr bgcolor="eeaaaa" >
						<td class="query" onClick="cfdump_toggleRow_qry(this);" >CACHED</td>
						<td>
			false
		</td>
						</tr>
					
				
					
					
				
					
					
						<tr bgcolor="eeaaaa" >
						<td class="query" onClick="cfdump_toggleRow_qry(this);" >EXECUTIONTIME</td>
						<td>
			0
		</td>
						</tr>
					
				
					
					
				
					
					
				
					
					
						<tr bgcolor="eeaaaa" >
						<td class="query" onClick="cfdump_toggleRow_qry(this);" >SQL</td>
						<td>
			SELECT EventID, EventTitle, locationname, ShortDescription, StartTime, EndTime, 
		  EventDate, eventduration, timezone
  		  FROM event
		  LEFT OUTER JOIN location ON event.locationid = location.locationid
		  LEFT OUTER JOIN clubs ON event.calendarid = clubs.clubid
		  WHERE event.eventid = ? 
		  AND event.calendarid = ?
		</td>
						</tr>
					
				
					
					
						<tr bgcolor="eeaaaa" >
						<td class="query" onClick="cfdump_toggleRow_qry(this);" >SQLPARAMETERS</td>
						<td>
			
				<table class="cfdump_array">
				<tr><th class="array" colspan="2">array
				</th></tr>
				

				
				
					
					<tr><td class="array">1</td>
					<td>

					
                    	
							
			215410
		
                        
                    

					</td></tr>
				
					
					<tr><td class="array">2</td>
					<td>

					
                    	
							
			120174
		
                        
                    

					</td></tr>
				

				
			</table>
		
		</td>
						</tr>
					
				
			
			
			
		</table>
		
		





Before convert: 03/20/2009 10:00 AM ~ 03/20/2009 3:00 PM<br />





Converted to start GMT:14:00:00<br>
Converted to end GMT:19:00:00



{ts '2009-03-20 14:00:00'} {ts '2009-03-20 19:00:00'}