search : datetime

select a category, or use search below
(searches all categories and all time range)

displaying top 100 results

Datetime functions return incorrect / inconsistent results
Bug 86140:-(Watson Migration Closure)[maestrofjp] The function ParseDateTime() incorrect parses Unix Datetime strings
Comment on new date/time function for returning date/time/datetime in ISO8601 by External U.
Comment on new date/time function for returning date/time/datetime in ISO8601 by External U.
Comment on new date/time function for returning date/time/datetime in ISO8601 by External U.
Require a separate function to differentiate between datetime Object and datetime String.
Comment on Require a separate function to differentiate between datetime Object and datetime String. by External U.
Comment on Require a separate function to differentiate between datetime Object and datetime String. by External U.
Comment on new date/time function for returning date/time/datetime in ISO8601 by External U.
6048839 CF-4204933 A. B. Let's then apply the code I gave you: string function convertLocalToUTC (date localDatetime, string timezone) { var localFormat=createobject("java","java.text.SimpleDateFormat").init("yyyy-MM-dd HH:mm:ss"); var local
Extension to 3309220 . Change of behaviour from CF 9 when persisting UTC date/time
2609378 CF-3852070 External U. forgot to add variable for datetime
6048839 CF-4204933 A. B. For the time being, you might like to use the following functions: string function convertUTCToLocal (date utcDatetime, string timezone) { var utcFormat=createobject("java","java.text.SimpleDateFormat").init("yyyy-MM-dd HH:mm:ss"); var utc
Comment on Require a separate function to differentiate between datetime Object and datetime String. by External U.
Comment on Require a separate function to differentiate between datetime Object and datetime String. by External U.
Comment on new date/time function for returning date/time/datetime in ISO8601 by Immanuel N.
Comment on new date/time function for returning date/time/datetime in ISO8601 by External U.
4161070 CF-4201805 Aaron N. Also, implementing this would create conflict with DateTime's .format(), if ever a future CF version adds DateTime member functions onto numeric. So that is a second reason for deferral.
Comment on new date/time function for returning date/time/datetime in ISO8601 by Aaron N.
new date/time function for returning date/time/datetime in ISO8601
Comment on [ANeff] Bug for: WDDX (correct) vs JSON (incorrect) wrt DateTime by Aaron N.
CF2018 CF_SQL_TIMESTAMP / MSSQL "datetime" fields not matching when milliseconds is .880 ( or any trailing zero )
3512827 CF-4199746 Alexander H. Our local.ExpiresDate variable should have a date/time object that is 15 hours in the future. Unfortunately running this code anytime after 9am local server time will result in an error like the following. The expected result would be no error. The endtime
Comment on [ANeff] Bug for: WDDX (correct) vs JSON (incorrect) wrt DateTime by Aaron N.
Comment on CFFiddle for Spreadsheet, List, Struct, and Date/Time functions by Saurav Ghosh
2613366 CF-3328875 Language Dave Cordes TimeFormat Function Bug w/Local2Utc Duplicate ID: CF-3323800 Problem Description: Formatting a date/time string using the Local2Utc function reverts to the local server time. Steps to Reproduce: Actual Result: Actual result for the timestamp
2608396 CF-4102485 External U. Hi Immanuel, For date, time and date+time? All 3? Thanks!, -Aaron
Comment on DateTime conversion to UTC seems to have a bug by External U.
Comment on DateTime conversion to UTC seems to have a bug by External U.
Comment on DateTime conversion to UTC seems to have a bug by Vamseekrishna N.
Comment on casting to DATE do not do what they imply they do: it simply returns a full date+time. by Himavanth R.
Comment on Extension to 3309220 . Change of behaviour from CF 9 when persisting UTC date/time by External U.
Comment on Extension to 3309220 . Change of behaviour from CF 9 when persisting UTC date/time by External U.
Comment on Extension to 3309220 . Change of behaviour from CF 9 when persisting UTC date/time by Vamseekrishna N.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Comment on Bug 72825:(Watson Migration Closure)The default date/time notation in log files is displayed as by External U.
Comment on Bug 72825:(Watson Migration Closure)The default date/time notation in log files is displayed as by External U.
Comment on Require a separate function to differentiate between datetime Object and datetime String. by Aaron N.
Comment on [ANeff] Bug for: WDDX (correct) vs JSON (incorrect) wrt DateTime by Aaron N.
3557837 CF-4199892 Aaron N. Hi Adobe, I am requesting that more members of the ColdFusion team read my last few comments on this ticket. Usage of DateTime setter methods leads to silent corruption when their input DateTime variable's type changes from String to OleDateTime. THIS MUST NOT HAPPEN
Comment on Require a separate function to differentiate between datetime Object and datetime String. by External U.
Comment on new date/time function for returning date/time/datetime in ISO8601 by External U.
Comment on spreadsheetwrite autosize does not work to re-size columns with datetime values. by External U.
Comment on Extension to 3309220 . Change of behaviour from CF 9 when persisting UTC date/time by Himavanth R.
Comment on ColdFusion 10 fails to insert utc datetime in right format by External U.
Charlie Arehart Thanks, Anit. And I see in fact that the blog posts on the front page are starting to reflect the changes you are doing. Sadly, the same problem exists as before: it shows their date/time as being "minutes ago" --which of course is the date/time reflecting when you have just edited
MySQL 5.6 datetime rounding error
Bug 87144:-(Watson Migration Closure)document the now undocument getTime() method on cf datetime objects & make it official
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
[ANeff] Bug for: WDDX (correct) vs JSON (incorrect) wrt DateTime
casting to DATE do not do what they imply they do: it simply returns a full date+time.
spreadsheetwrite autosize does not work to re-size columns with datetime values.
")',value:dateTimeFormat(createDate(2018,1,2), "iso")} ] myTimeArray = ["time"][] myDateTimeArray = ["datetime"][] values.each(function(element,index) { writeOutput("") try { myTimeArray.append(element.value) writeOutput('- ' & element.label & ' is a valid "time"') } catch(any e) { write
CFFiddle for Spreadsheet, List, Struct, and Date/Time functions
2673481 CF-4126505 Language Aaron Neff [ANeff] Bug for: dateTimeFormat(dateTime, "iso") truncates milliseconds dateTimeFormat(dateTime, "iso") truncates milliseconds Repro: dateTime = createDateTime(2016,1,3,1,2,3); dateTime = dateAdd("l", 123, dateTime); write
5665413 CF-4204276 Language : Member Functions ParseDateTime() conversion issue Problem Description: Date/Time values from a database query, when run through ParseDateTime() are not converted to valid datetime objects. Instead, they retain their original string value, causing all sorts of issues
2673556 CF-4126413 S P. The fix will be available in the update 2 of ColdFusion 2016. It has handled the date/time in-built functions and mathematical in-built functions that return integers. Thanks!
Comment on DateTime conversion to UTC seems to have a bug by External U.
2610458 CF-3700851 Rupesh K. Makes sense. Probably what we can do is - if the default parsing fails, we can try to parse it as ISO date. http://www.w3.org/TR/NOTE-datetime
2610459 CF-3700847 External U. Current link for the referenced article is: http://blog.adamcameron.me/2014/01/bugs-in-odbc-datetime-formatting.html
2611154 CF-3636794 External U. So to be clear: casting to TIME will result in the value having just a time component; but the DATE one will still return a DATE/TIME because of backwards compat concerns? If so: yeah, makes sense. Cheers. -- Adam
Comment on spreadsheetwrite autosize does not work to re-size columns with datetime values. by External U.
Comment on Extension to 3309220 . Change of behaviour from CF 9 when persisting UTC date/time by Piyush K.
Comment on Extension to 3309220 . Change of behaviour from CF 9 when persisting UTC date/time by External U.
Comment on Extension to 3309220 . Change of behaviour from CF 9 when persisting UTC date/time by External U.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Comment on DateConvert("local2Utc",now()) Breaks Other Date/Time Functions by External U.
Comment on ColdFusion 10 fails to insert utc datetime in right format by Himavanth R.
Comment on Bug 76746:(Watson Migration Closure)datetime conversion to/from WDDX doesn't honor DST by Adobe D.
4331464 CF-4202450 Aaron N. Related thread: https://forums.adobeprerelease.com/coldfusionpr/discussion/404/cf-4165524-datetime-functions-return-incorrect-inconsistent-results
3557837 CF-4199892 Aaron N. Fun will be when a per-app setting is introduced to cause deserializeJSON() to deserialize ISO8601 strings to date-time. Sit back. Grab popcorn.
Comment on Bug 76746:(Watson Migration Closure)datetime conversion to/from WDDX doesn't honor DST by Aaron N.
2609313 CF-3859758 External U. I agree in principle with the Adam and Tom. Adobe is too aggressive with trying to accommodate date/time fragments. Maybe we need an IsTime() function to validate time-only strings, and only have IsDate() return true for valid dates or full date/time strings. In any
Comment on ColdFusion 10 fails to insert utc datetime in right format by Himavanth R.
datetime numbers (by adding the DST offset amount) to datetime objects if they 1) occur on a DST changeover day -and- 2) occur after the DST changeover. Thanks!, -Aaron
Bug 83884:When Inserting or Updating a datetime field in SQL Server with #createODBCDateTime()# or #createODBCTime()# it throws a conversion error from varchar data type to (small)datetime data type (out-of-ra
4284960 CF-4202293 Functions : UDF [ANeff] Bug for: invalid UDF argument types should not be allowed Issue: invalid UDF argument types should not be allowed Repro: datetime function f1(myArg) {return ARGUMENTS.myArg;} writeDump(f1(createDateTime(2018,1,2,3,4,5))); //Actual and Expected
2613274 CF-3336205 Scheduler Aaron Neff [ANeff] Bug for: cfschedule falsely says exclude date format invalid Currently, for the exclude attribute: 1) date/time objects are valid, even in an array 2) numeric dates are only valid if not in an array 3) date/time objects and numeric dates cannot
ColdFusion 10 fails to insert utc datetime in right format
Bug 72825:(Watson Migration Closure)The default date/time notation in log files is displayed as
5623587 CF-4204191 Functions : Datetime CreateODBCDateTime() with DateFormat() and CreateODBCTime() results in incorrect ODBCDateTime output Problem Description: When creating a ODBC DateTime string, if you Wrap a DateFormat() and CreateODBCTime() in a CreateODBCDateTime(), the Output
Comment on DateTime conversion to UTC seems to have a bug by External U.
. We store all our datetimes in UTC in the database. Datetime values from a query resultset are stored as OleDateTime objects. This means if you wanted to get the age of a record, you would first need to convert the result of now() to UTC. This gets you an UTCOleDateTime object. When you do a
is not the last day of march, so we were not considering it as one month. Checked in the joda-time library and moment.js. DateTime date = new DateTime().withDate(2001, 02, 28); System.out.println(date); DateTime newDate = new DateTime().withDate(2001, 03, 28); // DateTime newDate = date.plusMonths(1); System
Comment on Extension to 3309220 . Change of behaviour from CF 9 when persisting UTC date/time by External U.
turn on and can see that the file path is correct. Once I change the text and select the folder from  CFadmin, I get the reply "Server has been updated successfull". It looks like everything work but when I reload the page  "test.cfm" file but I still see the old version of it. I can see the datetime
2608415 CF-4100122 Language : Functions Aaron Neff [ANeff] ER for: ISO 8601 support in dayOfWeek() dayOfWeek() doesn't use the ISO 8601 standard. #3765535 and #3917706 are updating the date/time format functions to support ISO 8601. This ER is to do the same for dayOfWeek(). Example: dateTime
and it will be correct. But when when I use the value in cfqueryparam (cfsqltype="cf_sql_timestamp"), it inserts the wrong value (seems to be the local time instead of the utc time). Steps to Reproduce: Create the following database table: - id (int, autoincrement) - now (datatime) - nowToUTC (datetime) - now
2613612 CF-3200965 AJAX : Plumbing Amit Yathirajadasan SerializeJSON returns wrong date for UTC date Problem Description: If you convert a Now() to UTC and then send it through SerializeJSON, it returns the local datetime and not the UTC datetime. Steps to Reproduce: Actual Result: The above
date/time the task was successfully executed as well as the next date/time the task was scheduled to execute. This would be invaluable for monitoring and troubleshooting. Method: Result: ----------------------------- Additional Watson Details ----------------------------- Watson Bug ID: 3035817
4486139 CF-4202965 Tags DateConvert Function seems corrupt. Problem Description: Using DateConvert() inside DateAdd() creates a corrupt date/time object. Please refer to this conversation https://forums.adobe.com/message/10459206#10459206 Steps to Reproduce: Please refer to this conversation
4313486 CF-4202393 Aaron N. Hi Adobe, Regarding #1: The correct solution would be to fix JSON serialization of DateTime to store in a standardized (ISO8601) format. Regarding #2: `DeserializeJSON()` already has a `strictMapping` parameter that "specifies whether to convert the JSON strictly
2612885 CF-3374275 Aaron N. Hi all, `myDateTime.setYear(2018)` mutates myDateTime. This is bad b/c CF treats strings as date-time whenever possible. Let's say an array is set earlier in the code: ….then, somewhere later in the code (even within another .cfm or .cfc or UDF body), the array
Michaela Light Better Time and Number Formats with ColdFusion In this article, you will learn: Why these functions are so important for CIOs The ColdFusion Number Format The ColdFusion Date Format The ColdFusion Time Format The ColdFusion DateTime Format What makes these functions are so important
Charlie Arehart We can't correct blog comments, so I will offer here that in my next-to-last paragraph, I of course meant to open it as: Can you please investigate that behavior, and hopefully change it, so that the date/time shown reflects the date CREATED rather than when UPDATED?