TryCF Gist

trycf-gist-1661440825581-e1515470-f8f1-3b77-9f3c-8bf093c9a1e9.cfm

<cfscript>

public function fixMyDate(any dateToFix){
    writeOutput("Starting with : #mytimeObj#" & "<br />");
    
    try {
        var dateToSave = arguments.dateToFix.parseDateTime();
    } catch (any e) {
        // parseDateTime() failed because - I am already a dateTime Object!
        var dateToSave = arguments.dateToFix;
    }

    return dateToSave;
}


//Start with a TS object like Lucee gives you
mytimeObj = createDateTime(2022, 08, 25, 06, 30, 00);

// run the function that works regardless of ACF of Lucee
myResult = fixMyDate(mytimeObj);
writeOutput("insert into myTable (theTSColumn) values ('#dateTimeFormat(myResult, 'YYYY-MM-dd HH:nn:ss')#')" & "<br /><br />");


// Start with a string like you get from ACF
mytimeObj = "2022-08-25 06:30:00.0";

// run the Same function that works regardless of ACF of Lucee
myResult = fixMyDate(mytimeObj);
writeOutput("insert into myTable (theTSColumn) values ('#dateTimeFormat(myResult, 'YYYY-MM-dd HH:nn:ss')#')" & "<br />");

</cfscript>