Skip to Main Content
Programming ColdFusion MX, 2nd Edition
book

Programming ColdFusion MX, 2nd Edition

by Rob Brooks-Bilson
August 2003
Intermediate to advanced content levelIntermediate to advanced
1140 pages
68h 45m
English
O'Reilly Media, Inc.
Content preview from Programming ColdFusion MX, 2nd Edition

Name

GetNumericDate

Synopsis

                  
                  
                  GetNumericDate(date)

Returns the specified date/time as a real number. Storing dates in this manner allows ColdFusion to quickly and efficiently store and manipulate dates and times. The date is stored as the integer part of the number, and the time is stored as the fractional part. 0 represents 12:00 AM on 12/30/1899. The following example returns the numeric date representing 12/31/2002 at 7:00 PM:

<cfoutput>#GetNumericDate('12/31/2002 19:00:00')#</cfoutput>

7:00 PM on 12/31/2002 would be 37621.7916667. The whole part of the number represents 37621 days since 12/30/1899; 0.7916667, or 7:00 PM is obtained by dividing the hour (19) by the total number of hours in a day (24).

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Programming ColdFusion

Programming ColdFusion

Rob Brooks-Bilson

Publisher Resources

ISBN: 0596003803Supplemental ContentErrata Page