v5:reference:connection:properties
This is an old revision of the document!
Public Properties Of The Connection
The Connection Object exposes numerous properties that can be used inside SQL statements to create portable statements. For example, to create a portable SQL statement that will return a column in uppercase no matter which database is in use, use the $db→upperCase property.
String Handling
| Property | Description |
|---|---|
| $substr | Returns the substring operator. Also available as a method substr() |
| $length | Returns a length operator |
| $random | Returns the random number function |
| $upperCase | The uppercase function |
| $maxblobsize | The maximum size of data that can be inserted into a blob field. Some drivers return -1 as the value, effectively limitless size |
Date & Time
| Property | Description |
|---|---|
| $sysDate | Returns the current local date in Y-m-d format |
| $sysTimeStamp | Returns the current local date/time in Y-m-d H:i:s format |
| $sysUTimeStamp | Returns the current timestamp accurate to the microsecond or nearest fraction |
v5/reference/connection/properties.1615593809.txt.gz · Last modified: 2021/03/13 01:03 by mnewnham