DateTime DBParm parameter for Oracle interfaces
When you create a profile to access an Oracle database through
one of the Oracle database interfaces, the syntax for setting the
DateTime DBParm parameter in the development environment has been
simplified in Version 6 and later versions. (The syntax for setting
DateTime in a PowerBuilder application script is unchanged.)
To set a value for DateTime, specify the following value in
the DateTime Format box on the Syntax tab in the Database Profile
Setup dialog box:
|
1 |
<span>DateTime_format</span> |
where DateTime_format is the
DateTime format you want PowerBuilder or InfoMaker to use when it
builds a SQL UPDATE statement to update a data source. For example:
|
1 |
m/d/yy h:mm am/pm |
PowerBuilder or InfoMaker generates the correct Oracle syntax
for DateTime and saves your setting in the initialization file as
follows:
|
1 |
DBParm=DateTime=' ''''m/d/yy h:mm am/pm'''' ' |