sql - how to know if between 2 date's it past 5 days - Oracle 10g? -


I have two dates:

1) 01/05/2009
2) 06 / 05/2009

How do I know that there are 5 days between them?

In your example, I think the date DD / MM / Y The YYY format is written in. You can do this:

  Select when the stomach (At DT ('01 / 05/2009 ',' DD / MM / YYYY ') - to_date ('06 / 05/200 9 '' DD / MM / YYYY ')) = 5 Then' yes' and 'no' ends in double form as ARE_DATES_5_DAYS_APART;  

If there are two columns in the two dates table, then use the table name instead of "double" in the above query.


Comments

Popular posts from this blog

MySql variables and php -

url rewriting - How to implement the returnurl like SO in PHP? -

kernel - How to create a "Block device" in Windows -