
Contents > CFML Reference > ColdFusion Functions > Functions by category > Date and time functions

Date and time functions

CreateDate	DateFormat	GetTimeZoneInfo	MonthAsString
CreateDateTime	DatePart	Hour	Now
CreateODBCDate	Day	IsDate	ParseDateTime
CreateODBCDateTime	DayOfWeek	IsLeapYear	Quarter
CreateODBCTime	DayOfWeekAsString	IsNumericDate	Second
CreateTime	DayOfYear	LSDateFormat	TimeFormat
CreateTimeSpan	DaysInMonth	LSIsDate	Week
DateAdd	DaysInYear	LSParseDateTime	Year
DateCompare	FirstDayOfMonth	LSTimeFormat
DateConvert	GetHttpTimeString	Minute
DateDiff	GetTickCount	Month


Contents > CFML Reference > ColdFusion Functions > Functions by category > Date and time functions

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.

Comments

MaestroFJP said on Jun 21, 2004 at 7:55 AM :

FYI, coldfusion/java incorrectly stores the a default MySQL datetime of 0000-00-00 00:00:00 as 0002-11-30 00:00:00.0 due to the fact that is not a valid datetime in Java. Java automatically stores it as a default escape string of 0002-11-30 etc. Beware of using MySQL default datetime escape string - use NULL instead

More info about this, now classified, NON-bug at:
http://bugs.mysql.com/bug.php?id=3331

.pjf

RSS feed | Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functio6.htm