ColdFusion UDF Library - DateFromNumber

December 16th, 2008
«« Back to ColdFusion Library

Category:
   DATE

Description:
   Takes a numeric value as seconds from the offset date and converts it to a datetime object

Parameters:
  1. number (Numeric, required)
           The numeric value you wish to convert to a DateTime Object

  2. offset (DateTime, Default: 01/01/1970)
           The date offset you wish to use. Sql Server uses the default.


Returns:
       DateTime

Requires:
       

Sample Use:
       

Copy to Clipboard
function DateFromNumber(number){
	var offset = createDate(1970,1,1);
	if (arrayLen(arguments) gte 2 and isDate(arguments[2]))offset = arguments[2];
	return dateConvert("utc2local",dateAdd("s",number,offset));
}
// http://www.programmers.org/index.php/coldfusion-udf-library/?ckey=6&function=DateFromNumber
  1. No comments yet.
  1. No trackbacks yet.