About Me
I am Carson McDonald a software engineer and this blog is a small slice of what I do every day. I started developing software in 1989 and since then have work with a wide range of languages and systems.
You can also find me at the following:
Twitter
LinkedIn
GitHub
Stack Overflow
Friend Feed
Converting unix or java timestamps (time since the epoch) to real dates with Oracle
A few days ago I made use of a couple Oracle built in functions and it made me happy I didn't have to write a stored proc or some type of mini-app to do it. I needed to parse a timestamp out of a field that was put there by a java program. The timestamp was just the output of System.currentTimeInMillis() and was concatenated onto some other information.
It took a little digging to find out how to convert a epoch style timestamp but here it is:
Note that I convert the output from GMT to EDT here.
Tags: java, oracle