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

AI generated answer (using internal Slack threads):

Based on the conversations, you can use the

TO_DATE

function in your SuiteQL query to compare the datetime column with a specific datetime value. Here is an example of how you can do it:

sql
SELECT *
FROM your_table
WHERE your_datetime_column = TO_DATE('2022-05-11 18:08:09', 'YYYY-MM-DD hh24:mi:ss')

In this query, replace

your_table

with the name of your table and

your_datetime_column

with the name of your datetime column. The

TO_DATE

function is used to convert the string '2022-05-11 180809' to a datetime value in the format 'YYYY-MM-DD hh24miss', which can then be compared with the datetime column in your table. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

Can you do this without using TO_DATE?