DateTime

Description

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

Applies to

ODBC
O84 Oracle 8.x and Oracle8i
O90 Oracle9i
O10 Oracle 10g

Syntax

The syntax you use to specify the DateTime 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 DateTime format.

In code, you must use the following syntax:

ODBC syntax DataWindow Designer parses the backslash followed by two single quotes (\'') as a single quote when it builds the SQL UPDATE statement.

DateTime = ' \''DateTime_format\'' '

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

DateTime = ' ''''DateTime_format'''' '

Parameter	Description
' \'' ' ''''	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 DateTime 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.
DateTime_format	The DateTime format you want DataWindow Designer to use when it builds a SQL UPDATE statement to update a data source in the painter. For more on display formats, see the User’s Guide.
\'' ' '''' '	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 DateTime format and the four single quotes.

Parameter

Description

' \''

' ''''

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 DateTime 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.

DateTime_format

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

For more on display formats, see the User’s Guide.

\'' '

'''' '

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

Default

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

DBMS	Date default value
ODBC	If no value is specified for the DateTime parameter, DataWindow Designer looks for a DateTime format in the section for your ODBC driver in the PBODB105 initialization file. If no DateTime format is found in the initialization file, DataWindow Designer uses the ODBC DateTime format escape sequence.
Oracle	The default Oracle DateTime format. For information, see your Oracle documentation.

DBMS

Date default value

ODBC

If no value is specified for the DateTime parameter, DataWindow Designer looks for a DateTime format in the section for your ODBC driver in the PBODB105 initialization file. If no DateTime format is found in the initialization file, DataWindow Designer uses the ODBC DateTime format escape sequence.

Oracle

The default Oracle DateTime format.

For information, see your Oracle documentation.

Examples

About these 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:

m/d/yy h:mm am/pm

Example 1 (ODBC, and OLE DB syntax)

To specify that DataWindow Designer 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 tab in the Database Profile Setup dialog box:
```
m/d/yy h:mm am/pm
```

Application Type the following in code:

SQLCA.DbParameter = "DateTime=' ''m/d/yy h:mm am/pm\'' '"

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

UPDATE FILES

SET TIMESTAMP='4/2/06 3:45 pm'

Example 2 (Oracle syntax)

To specify that DataWindow Designer 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 tab in the Database Profile Setup dialog box:
```
m/d/yy h:mm am/pm
```

Application Type the following in code:

SQLCA.DbParameter="DateTime=' ''''m/d/yy h:mm am/pm'''' '"

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

UPDATE FILES

SET TIMESTAMP = '4/2/06 3:45 pm'

DateTime

Description

Applies to

Syntax

Default

Examples

About these examples

Example 1 (ODBC, and OLE DB syntax)

Example 2 (Oracle syntax)

See also