Also, the TLDR of my last comment that I wrote to you includes the code I was noticing the error. I had also previously tested with coalesce and to_char() :

COALESCE(lastmodifieddate, '1900-01-01 00:00:00') as lastmodifieddate

I see the error:

java.sql.SQLException: [NetSuite][OpenAccess SDK JDBC Driver][OpenAccess SDK SQL Engine]

Failed to retrieve data. Error ticket# mcwb7tcx1eia537oa41ma