chonchanan.p

My Stuff

Comments

@Nicole Mendoza-Oracle It's work, I'm really thank you for your help.

in How to solve error when using lastmodifieddate with WHERE in SQL query? Comment by chonchanan.p Jan 19, 2023 2:01AM
@Nicole Mendoza-Oracle Can I ask 1 more question? From the picture, I use ...WHERE to_char(lastmodifieddate) >= '16/01/2023' but I got the data from date 19/12/2022 also. How can I fix this? Thanks in advance for your help.

in How to solve error when using lastmodifieddate with WHERE in SQL query? Comment by chonchanan.p Jan 18, 2023 6:13AM
@Nicole Mendoza-Oracle From your answer. I got "SELECT TOP 10 * FROM "NS Connect"."transaction" WHERE to_char(lastmodifieddate) = '16/06/2016'" which is work for me, thank you.

in How to solve error when using lastmodifieddate with WHERE in SQL query? Comment by chonchanan.p Jan 18, 2023 3:40AM