suiteql sql query to get table values whose datetime column equals "2022-05-11 180809.000000" without using TO_DATE

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you can directly use the datetime string in your SuiteQL query without the need for the TO_DATE function. This is because NetSuite's SuiteQL can handle datetime strings directly if they are in the standard format. Here is an example of how you can structure your SuiteQL query:

sql
SELECT *
FROM your_table
WHERE your_datetime_column = '2022-05-11 18:08:09.000000'

Please replace

your_table

and

your_datetime_column

with your actual table name and datetime column name. Remember, this approach works well if your datetime string is in the standard format. If it's not, you might need to adjust the format of your datetime string to match the standard format. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******