Date & Joda DateTime

Its always been a challenge for me when it comes to "Dates" be it java or real life. I had a task to make all the dates in my project UTC dates. For newbeeis "UTC" date means the date should reflect date that would reflect the time at GMT at any given time. Which means you need to +/- the hours based on the offset from the GMT.

A quick and easy way to do this is using Joda DateTime. I used it and here is a sample code to illustrate how it can be implemented:


Its also possible to convert a local time to another timezone using this feature. For example from IST to EST using the same code  by adjusting the timezone constant.

However the challenge i faced was, I realized that my database (Oracle) used datatype "date" which has seamless integration with java.lang.Date. Converting a joda DateTime with timezone offset to java Date is a bit tricky. I found a DateFormat that suited my case: "yyyy-MM-dd'T'HH:mm:ss.SSSXXX".

Unfortunately this date format only works on Java7 and I was supposed to be Java6 compliant. After a lot for struggle looking for suggestions on forums I finally pulled out a old trick out of my new hat ;)

The code that worked for this conversion in my case was:


jodaDate.getYear() did not work for me as it returned extremely future date, centuries ahead of actual date. I actually used my business logic to compute the year.

Comments

Post a Comment

Popular posts from this blog

jQgrid reload with new data

To reload a jQGrid with fresh data you need to set the data parameter on the grid and invoke reload on it. jQuery("#promotionsGrid").setGridParam({ 'data': newData}).trigger("reloadGrid"); Here newData is a JavaScript array with which I need to re-load the grid. The important thing here is that I had to place this statement just before the grid initialization code even though the reload was expected on change event of a text box. Without that there was simply no effect on my grid!
Read more

Rich Client based UI technologies- A Comparison of Thick Client UI tools

Rich Client v/s Thin Client Software developers face many difficult decisions when building new applications, not the least of which is graphical user interface. There are various graphical user interface technologies used, but broadly they can be classified as Rich Client User interfaces and the thin client or web based user interfaces. To understand them better let us look at the history of rich and thin clients. While the Rich client GUI applications would support high quality end-user experience with features such a drag-and-drop, perspectives, customization, high speed local processing; it has had a traditional disadvantage of high deployment and upgrade costs. It was becoming highly difficult and costly to deploy and upgrade these applications. Then came the thin clients or the Web based applications. Thin clients solved many of the deployment and upgrade problems, but that was not without a cost, the cost was in terms of functionality and capability. Thin clients, based on
Read more

OSS and BSS Systems

Image
OSS (Operational Support Systems) Software (occasionally hardware) applications that support back-office activities which operate a telco’s network, provision and maintain customer services. OSS is traditionally used by network planners, operations, architects, support, and engineering teams in the service provider. Increasingly product managers and senior staff under the CTO or COO may also use or rely on OSS to some extent. BSS (Business Support Systems) Software applications that support customer-facing activities. Billing, order management, customer relationship management, call centre automation, are all BSS applications. BSS may also encompass the customer-facing veneer of OSS application such as trouble-ticketing and service assurance – these are back-office activities but initiated directly by contact with the customer. OSS/BSS Structure Communication between OSS and BSS Apart from service assurance activities being cross-OSS-BSS processes, there are as m
Read more