1 files changed, 31 insertions, 0 deletions
diff --git a/drivers/adodb-mssqlnative.inc.php b/drivers/adodb-mssqlnative.inc.php
index 36dc5433..6d6a0068 100644
--- a/drivers/adodb-mssqlnative.inc.php
+++ b/drivers/adodb-mssqlnative.inc.php
@@ -1008,6 +1008,37 @@ class ADODB_mssqlnative extends ADOConnection {
 
 		return $metaProcedures;
 	}
+	
+	/**
+	* An SQL Statement that adds a specific number of 
+	* days or part to local datetime
+	* 
+	* @param float $dayFraction
+	* @param string $date
+	*
+	* @return string
+	*/
+	public function offsetDate($dayFraction, $date = false)
+	{
+		if (!$date)
+			/*
+			* Use GETDATE() via systTimestamp;
+			*/
+			$date = $this->sysTimeStamp;
+		
+		/*
+		* seconds, number of seconds, date base
+		*/
+		$dateFormat = "DATEADD(s, %s, %s)";
+
+		/*
+		* Adjust the offset back to seconds
+		*/
+		$fraction = $dayFraction * 24 * 3600;
+		
+		return sprintf($dateFormat,$fraction,$date);
+
+	}
 
 }