Time database parameter

Description

When you update data in the DataWindow painter, PowerBuilder builds
a SQL UPDATE statement
in the background. The Time parameter determines how PowerBuilder specifies
a time 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 Time 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
time format.

In code, 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:

Time=' '''<span>time_format</span>''' '

1	Time=' '''<span>time_format</span>''' '

[Oracle syntax]

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

Time=' ''''<span>time_format</span>'''' '

1	Time=' ''''<span>time_format</span>'''' '

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 time 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 time format.
time_format	The time 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 time 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 time format and the four single quotes.

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 time 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 time format.

time_format

The time 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 time 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 time format
and the four single quotes.

Default

The default value for Time depends on the DBMS you are accessing:

DBMS	Date default value
JDBC	If no value is specified for the Time parameter, PowerBuilder looks for a time format in the section for your JDBC driver in the registry. If no time format is found in the registry, PowerBuilder uses the JDBC time format escape sequence.
ODBC	If no value is specified for the Time parameter, PowerBuilder looks for a time format in the section for your ODBC driver in the PBODB126 initialization file. If no time format is found in the PBODB126 initialization file, PowerBuilder uses the ODBC time format escape sequence.
Oracle	The default Oracle date format. For information, see your Oracle documentation.

DBMS

Date default value

JDBC

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

ODBC

If no value is specified for the Time
parameter, PowerBuilder looks for a time format in the section for
your ODBC driver in the PBODB126 initialization file. If no time
format is found in the PBODB126 initialization file, PowerBuilder uses
the ODBC time 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 Workhours by setting
the Start column to 08:30. This time is represented by the following PowerBuilder time
format:

hh:mm

hh:mm

Example 1 (JDBC and ODBC syntax)

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

Database profile

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

PowerBuilder

hh:mm

1

hh:mm
Application

Type the following in code:

PowerBuilder

SQLCA.DbParameter="Time=' '''hh:mm''' '"

1

SQLCA.DbParameter="Time=' '''hh:mm''' '"

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

UPDATE WORKHOURS

1	UPDATE WORKHOURS

SET START='08:30'

1	SET START='08:30'

Example 2 (Oracle syntax)

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

Database profile

Type hh:mm in the Time
Format box on the Syntax page in the Database Profile Setup dialog
box.
Application

Type the following in code:

PowerBuilder

SQLCA.DbParameter="Time=' ''''hh:mm'''' '"

1

SQLCA.DbParameter="Time=' ''''hh:mm'''' '"

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

UPDATE WORKHOURS

1	UPDATE WORKHOURS

SET START='08:30'

1	SET START='08:30'

Time – PB Docs 126

Time database parameter

Description

Controls

Syntax

Default

Examples

See Also

My Website Links