Category Archives

All info I can think of about mySQL, Oracle and DB 2

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket

Ugh, seen this error before?  I had it from a XAMPP installation where my Mac hard drive had some problems and I had to restore my drive from a time machine backup.  When I restored the files, it ends up I could no…

Connecting to and Testing Oracle

Let me first start by saying, I am not an Oracle expert.  I learn what I need to in order to get things done.  I don’t go digging into learning Oracle proactively, frankly because I am not a huge fan of it, I…

Converting Dates in Oracle

If you need a quick reference on how to convert SQL dates for use in a where clause in Oracle, I use the following format: TO_TIMESTAMP (‘12.31.2008:00:00:00′,’MM.DD.YYYY:HH24:MI:SS’) where you can replace the Dec 31, 2008 date with your date and alternatively, you can…

Using SQL Dates in Oracle

I came across a great link for handling dates in Oracle by Philip Greenspun. http://philip.greenspun.com/sql/dates.html Specifically this helps when fetching results by a given date range based on today’s date. Here is a hilight of this article in case it is no longer…

Categories