Home > database >  How in the middle of the two fields in the oracle database query need to the date of the urgent urge
How in the middle of the two fields in the oracle database query need to the date of the urgent urge

Time:09-16

The table name: rec_maim
Fields: statdate
Fields: uploaddate

How to take of these two fields I want time

Everyone's great spirit, genuflect is begged my small white one!

CodePudding user response:

For example...

CodePudding user response:

This mean?
Select * from rec_maim where your time between statdate and uploaddate?

CodePudding user response:

Not see, what's this demand?

CodePudding user response:

reference 1st floor ZJHZ_ leaf response:
, for example...

Two fields below the date of each time period, an upload date a closing date, I'd like to take this I want to date in the two fields

CodePudding user response:

The
reference 4th floor you a banana and shout! Response:
Quote: refer to 1st floor ZJHZ_ leaf response:
, for example...

Two fields below the date of each time period, an upload date a closing date, I want to take what I want in these two fields date


Or on the actual data is better

CodePudding user response:

Test data is given, in order to realize the effect!

CodePudding user response:

refer to 6th floor springs of water faint reply:
test data is given, to achieve the effect of!


Late, the building and had a son, have solved the

Portal: https://bbs.csdn.net/topics/392725044
  • Related