Such as I want to check the start time and end time 2017-02-01 2017-03-31 this period of time, when sent out is the period of 2017-02-01-2017-02-01

CodePudding user response:

After the to_char can joining together

CodePudding user response:

Can you say the detailed point

CodePudding user response:

 
With TB as (select to_date (' 2017-02-01 ') as fromdt, to_date (' 2017-03-31 ') as enddt from dual) 
The select to_char (fromdt, 'yyyy - mm - dd) | |' - '| | to_char (enddt,' - dd yyyy - mm) as shijian from TB 

CodePudding user response:

Upstairs is ~ ~ ~ ~