There was requirement, an attribute of type DATETIME is stored in the GMT format and it needs to be converted into CST format while presenting the data to end users in reporting tool(BO). In additional, we require to handle the DST(Day Light Savings) since the servers are present in U.S.
So, we know that during DST, the CST time would be equal to GMT- 5 hrs else GMT-6 hrs. The challenge was in figuring out the when the DST starts and ends every year.There were no built in functions available handling this scenario. After a quite good effort, i found function called TIMEZONE in DB2, which gives the difference between GMT and the time zone of the application server(The application servers installed at different locations around the world follow their specific timezone).So when i queried in my database, it returned - 6 hours, which is difference between CST & GMT.Still, i had a query how would the TIMEZONE variable adjusts during DST.
The trick is these databases were installed on AIX (OS) and the TIMEZONE variable gets the value from these servers.
So happily I used
DATE ATTRIBUTE + TIMEZONE = DATE (in CST FORMAT).
Hope this might help you guys in future.
- Upendra
Saturday, March 26, 2011
Saturday, January 15, 2011
Interview - Recruiters needs Mindset change
I have attended one interview few months back and wanted to share few thoughts related to it. This was first interview after i gained a professional experience.After 1st round(technical), i was promoted to second round( a sigh of relief). Here the second round goes,
"A panel of 3 people (experts in their own terms) on the other side of table.A discussion started a in usual mode like my experience technologies and blah, blah....Then first question started
1) How do u rate your self in XYZ technology? It created jargon in mind as i never rated myself.It's because i do not like to map my knowledge to the metrics(if existed).But, i have to deceive my own perception and told X/Y metric. Then the battle started,I was doing pretty good and fidget triggered when the turn shifted to other member in panel.He started asking questions (more) in hardware perspective which i have never invaded myself.I took some time to respond as these were new to me,but the interviewer was not willing to cooperate as he was expecting for instants from me. So, things started turning bad as he was pounding on me like a mad bull but, i was resisting myself to avoid his tantrums . He finally told "You need to re-rate yourself". I lost my confidence and the other member in panel asked some queries (even though quite simple to me) where I was not able to respond becuase i lost the momentum after the feedback from one of the member panel.
As expected, i was not promoted to the next round.I came out of office in puzzled mode and started questioning myself "What went wrong?" Days passed and finally I was successful in finding the answer.Let me share that
1) When interviewer asked about rating?I should have revealed my thoughts on it.A small LIE has cost-ed my confidence, rather to say I learn t lesson for LIFE.
2) I agree this is competitive world which expects ready-made solutions,zero tolerance and cost effective(meaning TIME).But an important thing which we miss is , we need time for making decisions as it takes lot to come to conclusion like identifying,evaluating,weighing,sensible(meant logical) the multiple options.Its time for DECISION MANAGEMENT and i started researching on it.
Signing OFF for the day
-- Upendra
"A panel of 3 people (experts in their own terms) on the other side of table.A discussion started a in usual mode like my experience technologies and blah, blah....Then first question started
1) How do u rate your self in XYZ technology? It created jargon in mind as i never rated myself.It's because i do not like to map my knowledge to the metrics(if existed).But, i have to deceive my own perception and told X/Y metric. Then the battle started,I was doing pretty good and fidget triggered when the turn shifted to other member in panel.He started asking questions (more) in hardware perspective which i have never invaded myself.I took some time to respond as these were new to me,but the interviewer was not willing to cooperate as he was expecting for instants from me. So, things started turning bad as he was pounding on me like a mad bull but, i was resisting myself to avoid his tantrums . He finally told "You need to re-rate yourself". I lost my confidence and the other member in panel asked some queries (even though quite simple to me) where I was not able to respond becuase i lost the momentum after the feedback from one of the member panel.
As expected, i was not promoted to the next round.I came out of office in puzzled mode and started questioning myself "What went wrong?" Days passed and finally I was successful in finding the answer.Let me share that
1) When interviewer asked about rating?I should have revealed my thoughts on it.A small LIE has cost-ed my confidence, rather to say I learn t lesson for LIFE.
2) I agree this is competitive world which expects ready-made solutions,zero tolerance and cost effective(meaning TIME).But an important thing which we miss is , we need time for making decisions as it takes lot to come to conclusion like identifying,evaluating,weighing,sensible(meant logical) the multiple options.Its time for DECISION MANAGEMENT and i started researching on it.
Signing OFF for the day
-- Upendra
Subscribe to:
Posts (Atom)