silverstripe / silverstripe-mssql

            }

        }

        if (preg_match('/^now$/i', $date)) {

            $date = "CURRENT_TIMESTAMP";

        } elseif (preg_match('/^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$/i', $date)) {

            $date = "'$date.000'";

        }

        if ($format == '%U') {

            return "DATEDIFF(s, '1970-01-01 00:00:00', DATEADD(hour, DATEDIFF(hour, GETDATE(), GETUTCDATE()), $date))";

            user_error('datetimeIntervalClause(): invalid interval ' . $interval, E_USER_WARNING);

        }

        if (preg_match('/^now$/i', $date)) {

            $date = "CURRENT_TIMESTAMP";

        } elseif (preg_match('/^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$/i', $date)) {

            $date = "'$date'";

        }

        return "CONVERT(VARCHAR, DATEADD(" . $trans[strtolower($matches[2])] . ", " . (int)$matches[1] . ", $date), 120)";

    }

     */

    public function datetimeDifferenceClause($date1, $date2)

    {

        if (preg_match('/^now$/i', $date1)) {

            $date1 = "CURRENT_TIMESTAMP";

        } elseif (preg_match('/^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$/i', $date1)) {

            $date1 = "'$date1'";

        }

        if (preg_match('/^now$/i', $date2)) {

            $date2 = "CURRENT_TIMESTAMP";

            $date1 = "'$date1'";

        }

        if (preg_match('/^now$/i', $date2)) {

            $date2 = "CURRENT_TIMESTAMP";

        } elseif (preg_match('/^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$/i', $date2)) {

            $date2 = "'$date2'";

        }

        return "DATEDIFF(s, $date2, $date1)";

    }