Return
-
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.3951711 record(s) selected.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.