DateTimeFormat – PB Docs 126

DateTimeFormat database parameter

Description

When you update data in the DataWindow painter, PowerBuilder builds
a SQL UPDATE statement
in the background. The DateTimeFormat parameter determines how PowerBuilder specifies
a DateTime datatype when it builds the SQL UPDATE statement.
(A DateTime datatype contains both a date value and a time value.)

Controls

  • ADO.NET

  • OLE DB

  • SNC SQL Native Client for Microsoft SQL Server

Syntax

Parameter

Description

datetime_format

The datetime 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
.

Default

If no value is specified for the DateTimeFormat parameter, PowerBuilder does not
use a datetime datatype.

Usage

When you call stored procedures, the database server might
not accept the DateTime format built by PowerBuilder. If this occurs,
you can try to use another format. For example, for Microsoft SQL
Server, try this format:

PowerBuilder parses the backslash followed by two single quotes
(”’) as a single quote.

Examples

Assume you are updating a table named Files by setting
the Timestamp column to 4/2/06 3:45 pm. This DateTime
is represented by the following DateTime format:

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

  • Database
    profile

    Type the following in the DateTime 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
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x