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');
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