GetDB2TimeStamp(dateObj, emulateTick)
Last updated June 27, 2002
Version: 1 | Requires: ColdFusion 5 | Library: DatabaseLib
Description:
Takes a ColdFusion date object and returns a DB2 formatted timestamp.
A second parameter "emulateTick" determines if tick count emulation is added to the date object.
Return Values:
Returns a string.
Example:
#GetDB2TimeStamp(Now(), "Yes")#<BR>
#GetDB2TimeStamp(Now(), "No")#
</cfoutput>
Parameters:
| Name | Description | Required |
|---|---|---|
| dateObj | A data object. | Yes |
| emulateTick | A boolean. | Yes |
Full UDF Source:
<cfscript>
/**
* Takes a ColdFusion date object and returns a DB2 formatted timestamp.
*
* @param dateObj A data object. (Required)
* @param emulateTick A boolean. (Required)
* @return Returns a string.
* @author Chris Wigginton (cwigginton@macromedia.com)
* @version 1, June 27, 2002
*/
function getDB2TimeStamp(dateObj, emulateTick)
{
var tick = "000000";
// We can partially emulate milliseconds by
//grabbing the current tick and applying it to the date object
if(emulateTick IS "Yes")
tick = Right(GetTickCount(),3) & "000";
return DateFormat(dateObj, "yyyy-mm-dd-") & TimeFormat(dateObj, "HH.mm.ss.") & tick;
}
</cfscript>
Search CFLib.org
Latest Additions
cfRssFeed
2 day(s) ago
structBlend
23 day(s) ago
IsZIPUK
23 day(s) ago
getTagContentAll
29 day(s) ago
ListReturnDuplicat...
1 month(s) ago