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 legnth operator |
| $random | Returns the random number function |
| $upperCase | The uppercase function |
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.1615517772.txt.gz · Last modified: 2021/03/12 03:56 by mnewnham