Skip to Main Content
This is a BETA environment
This environment is only for testing and may be reset multiple times during the testing period. We will be frequently upgrading this BETA environment, so check back often for changes. Please assist us by providing feedback via the bug icon to the left of your profile avatar. For the current active community, visit https://community.oracle.com/tech/developers/.

Search results older than 50 days

Hi!
I have a table with a tent_recpdat field (date of receipt of the goods of type date (dd-mm-yyyy)), I need to make a select that brings me the results of receipts that are more than 50 days old, I tried the sql command below, but no results.
select tent_fornece_1, tent_nomefor_1, tent_nronota_1, datedif(day, tent_recpdat_1, getdate()) as dif_dias from notent where dif_dias > 50

Comments
Post Details
Added on Jan 14 2023
0 comments
26 views