Continuous Development Blog

I found it very interesting that these two methods are not working same

SELECT add_months(TO_DATE(’28-FEB-2007′), 1) FROM dual = 31-MAR-2007

while

java.util.Calendar c=..//28-FEB-2007
c.add(Calendar.MONTH,1); // gives 28-MAR-2007

which one is true ?
for the situation I am dealing java calculation is correct !

java vs Oracle and again winner is java !!!!

Image via Wikipedia

I change my development database to postgres SQL for a several reasons :

• I’am bored to mysql
• mysql do not give me entreprise database trust: looks so simple even too simple to offer to my customers. it suites for less complicated fast application.
• Last but most important reason it its Licensing !!!

Since I am very new to postgres I am playing with it. looking for new features and trying to solve compatibility problems

One good referance for people like me :

Converting mysql to Pstgresql

PS:
since I am using hibernate and so on no development required for this migration…