Category Archives: ORACLE

Oracle Function & .NET sysdate problem

After I shared one solution about oracle, iis and sysdate problem, I got another similar error. This time, the function was getting the paramater sysdate with time added. I noticed this because the function was calculating default insterest of a … Continue reading

Posted in .NET, IIS, ORACLE | Tagged , , | Leave a comment

Oracle sysdate year problem

I have been trying to solve the problem that I encounter when I call a Oracle function in my code. Oracle function takes one number and date as parameteres: MY_FUNCTION (NO IN NUMBER,DATE IN DATE) And I was calling the function … Continue reading

Posted in ORACLE | Tagged | Leave a comment

Query rows between two times

Posted in ORACLE, SQL | Leave a comment

Simple Oracle Database Query

Simple but needed.

Posted in .NET, ORACLE | Leave a comment

Number of days or weekdays between two days in ORACLE

if you remove count, it will give the list of dates between. (6,7) is the number of days in a week. Monday is 1, Tuesday is 2, if we change it as (1,2,3,4,5), it returns weekdays.

Posted in ORACLE | Leave a comment