Bundle ODBC database access layer. Connection manages database sessions; Statement and ParameterStatement execute SQL queries; ResultSet iterates over rows and extracts typed column values. Compile with -lib odbc.
Date
ODBC date
Operations
New # constructor
Copy constructor for System.Time.Date
New(date:System.Time.Date)Parameters
| Name | Type | Description |
|---|---|---|
| date | Date | System.Time.Date |
SetMonth #
Sets the month
method : public : SetMonth(month:Int) ~ NilParameters
| Name | Type | Description |
|---|---|---|
| month | Int | value |
SetYear #
Sets the year
method : public : SetYear(year:Int) ~ NilParameters
| Name | Type | Description |
|---|---|---|
| year | Int | value |
ToDate #
Converts a ODBC date into a system date
method : public : ToDate() ~ System.Time.DateReturn
| Type | Description |
|---|---|
| Date | system date |
Example
conn := Database.ODBC.Connection->New("mydsn", "user", "pass");
rs := conn->Select("SELECT created_on FROM events");
if(rs->Next()) {
d := rs->GetDate("created_on");
sys_date := d->ToDate(); # convert to System.Time.Date
sys_date->ToString()->PrintLine();
};
conn->Close();