August 2001
Intermediate to advanced
976 pages
38h 8m
English
DatePart
DatePart(datepart, date)Returns the specified part of a valid date/time object. Valid values
for the datepart parameter are:
s (second), n (minute),
h (hour), ww (week),
w (weekday), d (day),
y (day of year), m (month),
q (quarter), and yyyy (year).
If date1 is greater than
date2, a negative number is returned.
Examples:
<CFOUTPUT>
The current time and date is
#TimeFormat(Now( ),'hh:mm:ss tt')#, #DateFormat(Now( ),'mmmm dd, yyyy')#
<P>
<B>Second:</B> #DatePart('s', Now( ))#<BR>
<B>Minute:</B> #DatePart('n', Now( ))#<BR>
<B>Hour:</B> #DatePart('h', Now( ))#<BR>
<B>Week:</B> #DatePart('ww', Now( ))#<BR>
<B>Weekday:</B> #DatePart('w', Now( ))#<BR>
<B>Day:</B> #DatePart('d', Now( ))#<BR>
<B>Day of year:</B> #DatePart('y', Now( ))#<BR>
<B>Month:</B> #DatePart('m', Now( ))#<BR>
<B>Quarter:</B> #DatePart('q', Now( ))#<BR>
<B>Year:</B> #DatePart('yyyy', Now( ))#
</CFOUTPUT>Read now
Unlock full access