Differences

This shows you the differences between two versions of the page.

--- v5:reference:connection:offsetdate [2025/08/20 03:03] – fix and describe second arg mnewnham
+++ v5:reference:connection:offsetdate [2025/08/20 05:04] (current) – mnewnham
@@ Line 8: / Line 8: @@
   )
 </WRAP>
+==== Note ====
+Passing a decimal offset less than one without
+specifying a base date will always return the
+current date because the calculation time
+basis is always the beginning of the current date
 ===== Description =====
 The function ''offsetDate()'' returns a string with the native SQL functions to calculate future and past dates based on ''$isoDate'' in a portable fashion. If ''$isoDate'' is not defined, then the current date (at 12 midnight) is used.
@@ Line 20: / Line 27: @@
   * As string in the format "float/24" where the floating point number is the number of hours
-The $isoDate can be a basis date in ISO format, or skipped or false for today
+The $isoDate can be:
+   * A basis date in ISO format including a time portion, if a fractional calculation is required
+   * An SQL statement that produces an ISO date
+   * An SQL column if the method is to be used to calculate date offsets based on table values
+   * skipped or false for today
 ===== Example =====
 In Oracle, to find the date and time that is 2.5 days from today, you can use:
@@ Line 57: / Line 69: @@
 */
+</code>
+===== Example Generating A Date From a column Value ====
+In this example we would use the statement to return a date 7 days forward from the current value of the column "delivery date".
+<code php>
+$newDeliveryDate = $db->offsetDate(7,'delivery_date');
+$SQL = "SELECT $newDeliveryDate
+          FROM delivery_master
+         WHERE delivery_date = {$db->dbDate(date('Y-m-d')}".
 </code>