LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: JAWILBUR

Hello

Using a DB Query node, I am trying to add a line in my "where" clause on a DateTime column, but I continue to get an error suggesting to convert this field to a string. What format should I use?

Thanks

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: JAWILBUR

Here is the example of code I am putting into the DB query

select distinct
field1,
field2,

from ops$fre.sbb_base

where date(field2,"CCYY,MM,DD") <> "0001-01-01"

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

You need to use a SQL command that is compatible with the database you are accessing. (Don't use BrainScript code in the SQL)
For Oracle:

select distinct field1,field2,
from ops$fre.sbb_base
where field2 <> to_date('0001-01-01','CCYY-MM-DD')

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: JAWILBUR

Back to this thread, I believe the attached error when I open the brdViewer is related.


BrdViewer.jpg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

You are getting some records back with a date similar to 00-00-0000 or 0001-01-01
The 'error message' you are seeing with the BRD viewer affects the viewer only.. not the operation of the nodes on the server.