ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:reference:reference_index

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
v5:reference:reference_index [2025/07/11 01:42] – [Manipulating Dates & Times] mnewnhamv5:reference:reference_index [2025/07/18 03:36] (current) – [Manipulating Dates & Times] mnewnham
Line 124: Line 124:
 | [[v5:reference:connection:bindtimestamp|bindTimeStamp()]]     | Creates a portable timestamp field, for use in bind statements   || | [[v5:reference:connection:bindtimestamp|bindTimeStamp()]]     | Creates a portable timestamp field, for use in bind statements   ||
 | [[v5:reference:connection:dbdate|dbDate()]]                   | Returns a date formatted based on the setDateLocae() setting         |Date| | [[v5:reference:connection:dbdate|dbDate()]]                   | Returns a date formatted based on the setDateLocae() setting         |Date|
-| [[v5:reference:connection:dbtimestamp|dbTimeStamp()]]         | Creates a portable timestamp field, for use in SQL statements    || +| [[v5:reference:connection:dbtimestamp|dbTimeStamp()]]         | Returns a date/time formatted based on the setDateLocale() setting    DateTime|| 
-| [[v5:reference:connection:offsetdate|offsetDate()]]           | Creates a portable date offset field, for use in SQL statements  ||+| [[v5:reference:connection:offsetdate|offsetDate()]]           | Creates a statement to calculate a past or future date |Embeddable SQL|
 | [[v5:reference:connection:setdatelocale|setDateLocale()]]     | Sets a specified Date Format for a Locale              |Embeddable SQL| | [[v5:reference:connection:setdatelocale|setDateLocale()]]     | Sets a specified Date Format for a Locale              |Embeddable SQL|
 | [[v5:reference:connection:sqldate|sqlDate()]]            | Returns a portably-formatted date string from a timestamp database column       |Embeddable SQL| | [[v5:reference:connection:sqldate|sqlDate()]]            | Returns a portably-formatted date string from a timestamp database column       |Embeddable SQL|
 | [[v5:reference:connection:unixdate|unixDate()]]               | Uses ADODb to create date strings without times              |DateTime| | [[v5:reference:connection:unixdate|unixDate()]]               | Uses ADODb to create date strings without times              |DateTime|
 | [[v5:reference:connection:unixtimestamp|unixTimeStamp()]]     | Uses ADOdb to create date/time strings         |DateTime| | [[v5:reference:connection:unixtimestamp|unixTimeStamp()]]     | Uses ADOdb to create date/time strings         |DateTime|
 +| [[v5:reference:connection:day|day()]]            | Returns portable shortcut SQL to extract the day portion of a date  |Embeddable SQL|
 +| [[v5:reference:connection:month|month()]]            | Returns portable shortcut SQL to extract the month portion of a date  |Embeddable SQL|
 +| [[v5:reference:connection:year|year()]]            | Returns portable shortcut SQL to extract the year portion of a date  |Embeddable SQL|
 ==== Row Management ==== ==== Row Management ====
 |[[v5:reference:connection:affected_rows|affected_rows()]]|Returns the number of rows affected by the last operation| |[[v5:reference:connection:affected_rows|affected_rows()]]|Returns the number of rows affected by the last operation|
v5/reference/reference_index.1752190926.txt.gz · Last modified: by mnewnham