Select statements using TIMESTAMP_FORMAT function do not return any data. (4223225)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Select statements using TIMESTAMP_FORMAT function do not return any data.
Description

User running a Select using TIMESTAMP_FORMAT function as such:
SELECT * FROM <tablename> WHERE <columnname> = TIMESTAMP_FORMAT('2010-03-21 07:13:22', 'YYYY-MM-DD HH24:MI:SS')
Returns:
0 record(s) selected.

Running the same Select statement without TIMESTAMP_FORMAT returns data:
SELECT * FROM <tablename>

15 2010-03-21-07.13.22.395171
1 record(s) selected.
Resolution

WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad for DB2.
Defect ID

CR83416

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title