v5:reference:connection:properties
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
v5:reference:connection:properties [2021/03/12 03:52] – created mnewnham | v5:reference:connection:properties [2021/03/13 01:11] (current) – mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Public Properties Of The Connection====== | ====== 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 '' | + | 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 '' |
===== String Handling ===== | ===== String Handling ===== | ||
- | ^ Property | + | ^ Property |
- | | $substr | + | | $substr |
- | | $length | + | | $length |
- | | $random | + | | $random |
- | | $upperCase | + | | $upperCase |
+ | | $maxblobsize | ||
===== Date & Time ===== | ===== Date & Time ===== | ||
- | ^ Property | + | ^ Property |
| $sysDate | | $sysDate | ||
| $sysTimeStamp | Returns the current local date/time in Y-m-d H:i:s 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| | |
+ | ===== Database Specific Properties ===== | ||
+ | Some drivers expose database-specific properties. See the driver documentation for more information. |
v5/reference/connection/properties.1615517577.txt.gz · Last modified: 2021/03/12 03:52 by mnewnham