Handling Time Zone with .Net and Oracle RRS feed

  • Question

  • My application use .Net as front-end and Oracle as backend.

    We have Location master table where we will keep associated time zone. We need this time zone because application demands date time conversion form one location to another.

    This time zone conversion functionality  is required at both end .Net(C#) and Oracle(PL/SQL package)

    Problem starts here, .Net understand Microsoft Timezone version where as Oracle understand TZ version

    1.   Which time zone I should associate with location,

    2.    If I associate TZ time zone , then I can leverage inbuilt oracle functions for time zone conversion but  .Net  will not understand this.

    3.  If I associate MS time zone , then I can leverage .Net API for time zone conversion but Oracle will not understand this

    4.   Should I Associate either TZ or MS and then use a time zone mapper to map between TZ to MS

    I don’t  think I am the first person who come across this scenario , I would like to know how others approach the workaround and what is the best practices

    • Edited by BibhasCh Monday, July 27, 2015 3:18 AM
    Friday, July 24, 2015 6:41 AM


All replies

  • Can you store as a universal time and then the consumers will just convert to their time zone?

    Friday, July 24, 2015 3:35 PM
  • I understand but this will not help me. I have many locations and I need to calculate a date-time respect to the location and it's time zone.

    This calculation is required at  both end .Net and Oracle PL/SQL. Problem is , .Net and Oracle understand different time zone database.

    Let me know , if you have any solution.

    • Edited by BibhasCh Monday, July 27, 2015 3:18 AM
    Monday, July 27, 2015 3:17 AM
  • I'm assuming the time zones mappers will provide the same result for any given country and UTC value? If not you might want to try a specific library such as

    • Edited by pkr2000 Tuesday, July 28, 2015 7:24 AM
    • Marked as answer by BibhasCh Wednesday, July 29, 2015 12:45 PM
    Tuesday, July 28, 2015 7:17 AM