Category Archives: Databases

Why Brackets in SQL queries with SQL Server

It’s been long time since I worked with SQL Server last time. I have been working with Oracle and there are differences for sure. This one is simple. The brackets are required if you use keywords or special chars in … Continue reading

Posted in Databases, MSSQL, Uncategorized | Tagged | Leave a comment

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

Floor, Ceiling and Rounding with MySQL

I was trying to get the average solution time of issues in Redmine per tracker type. In order to get the average time, I first selected creation time of issue and extracted it from the date of solution of the issue (this … Continue reading

Posted in MySQL, Uncategorized | 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