garywaddell.com

Gary Waddell

Search

// archives

Database

RSS feed for this section

This category contains 3 posts

Connecting to and Testing Oracle

By garywaddell ⋅ July 14, 2011 ⋅ Post a comment

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 still prefer DB2, but enough of that This blog simply talks about [...]

Converting Dates in Oracle

By garywaddell ⋅ July 13, 2009 ⋅ Post a comment

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 parse the date using a different format string, as you see in [...]

Using SQL Dates in Oracle

By garywaddell ⋅ June 2, 2009 ⋅ Post a comment

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 active: You can query for shorter time intervals: select email, registration_date from [...]