Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Date – PB Docs 126 – PowerBuilder Library

Date – PB Docs 126

Date database parameter

Description

When you update data in the DataWindow painter, PowerBuilder builds
a SQL UPDATE statement
in the background. The Date parameter determines how PowerBuilder specifies
a date datatype when it builds the SQL UPDATE statement.

Controls

  • JDB JDBC

  • ODBC

  • O90 Oracle9i

  • O10 Oracle 10g

  • ORA Oracle 11g

Syntax

The syntax you use to specify the Date parameter differs slightly
depending on the database.

The Database Profile Setup dialog box inserts special characters
(quotes and backslashes) where needed, so you can specify just the
date format.

In a PowerBuilder application script, you must use the following
syntax:

[JDBC and ODBC syntax]

PowerBuilder parses the backslash followed by two single quotes
(''')
as a single quote when it builds the SQL UPDATE statement.

[Oracle syntax]

PowerBuilder parses each set of four consecutive single quotes
('''')
as a single quote when it builds the SQL UPDATE statement.

Parameter

Description

‘ ”’

‘ ””

JDBC and ODBC syntax

Type a single quote, followed by one space, followed by a
backslash, followed by two single quotes. There is no space between
the two single quotes and the beginning of the date format.

Oracle syntax

Type a single quote, followed by one space, followed by four
single quotes. There is no space between the four single quotes
and the beginning of the date format.

date_format

The date format you want PowerBuilder to
use when it builds a SQL UPDATE statement
to update a data source in the DataWindow painter.

For more on display formats, see the Users
Guide
.

”’ ‘

”” ‘

JDBC and ODBC syntax

Type a backslash, followed by two single quotes, followed
by one space, followed by a single quote. There is no space between
the end of the date format and the backslash.

Oracle syntax

Type four single quotes, followed by one space, followed by
a single quote. There is no space between the end of the date format
and the four single quotes.

Default

The default value for Date depends on the DBMS you are accessing,
as summarized in the following table:

DBMS

Date default value

JDBC

If no value is specified for the Date
database parameter, PowerBuilder looks for a date format in the section
for your JDBC driver in the registry. If no date format is found
in the registry, PowerBuilder uses the JDBC date format escape sequence.

ODBC

If no value is specified for the Date
database parameter, PowerBuilder looks for a date format in the section
for your ODBC driver in the PBODB126 initialization file. If no
date format is found in the initialization file, PowerBuilder uses
the ODBC date format escape sequence.

Oracle

The default Oracle date format.

For information, see your Oracle documentation.

Examples

About these examples

Assume you are updating a table named Employee by setting
the Startdate column to 2006-04-23. This date is represented by
the following date format:

Example 1 (JDBC and ODBC syntax)

To specify that PowerBuilder should use this format for the
date datatype when it builds the SQL UPDATE statement:

  • Database
    profile

    Type the following in the Date Format box on the Syntax page
    in the Database Profile Setup dialog box:

  • Application

    Type the following in code:

What happens PowerBuilder builds
the following SQL UPDATE statement
to update the table:

[Example 2 (Oracle syntax)]

To specify that PowerBuilder should use this format for the
date datatype when it builds the SQL UPDATE statement:

  • Database
    profile

    Type the following in the Date format box on the Syntax page
    in the Database Profile Setup dialog box:

  • Application

    Type the following in code:

What happens PowerBuilder builds
the following SQL UPDATE statement
to update the table:

See Also


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x