Friday, January 20, 2017

Oracle SQL query to search records created on weekends in B2B 10g

Oracle SQL query to search records created on weekends


select * from B2B_INSTANCEMESSAGE where DOCUMENTTYPE='850 4010'

 where
TO_CHAR (messagedatetime, 'DY', 'NLS_DATE_LANGUAGE=ENGLISH') IN ('SAT', 'SUN');

No comments:

Post a Comment