CFLib.org – Common Function Library Project

Description:
A function which returns a Beginning Of Day TimeStamp. For example, 1/1/2000 10:30 PM returns {ts '2000-01-01 00:00:00'}. Useful for SQL queries when users search by date ranges and you need to include all values by the beginning of a certain date period.

Return Values:
Returns a timestamp.

Example:

<cfset BOD = getBegOfDayTS("1/1/2000 10:30 PM")>
<cfoutput>#BOD#</cfoutput>

Parameters:

Full UDF Source:

<cfscript>
/**
 * A function which returns a Beginning Of Day TimeStamp. For example, 1/1/2000 10:30 PM returns {ts '2000-01-01 00:00:00'}.
 * 
 * @param date 	 Date to use. (Required)
 * @return Returns a timestamp. 
 * @author Sami Hoda (&#115;&#97;&#109;&#105;&#104;&#111;&#100;&#97;&#64;&#103;&#109;&#97;&#105;&#108;&#46;&#99;&#111;&#109;) 
 * @version 1, January 30, 2006 
 */
function getBegOfDayTS(date) {
	var vDate = date;	
	vDate = dateFormat(vDate, 'MM/DD/YYYY');
	vDate = DateAdd("h",00,vDate);
	vDate = DateAdd("n",00,vDate);
	vDate = DateAdd("s",00,vDate);
	
	return vDate;
}
</cfscript>