HOW U MAINTAIN THE TIME DIFFERENCE IN TIME DIMENSION IF U

adisheshu.dwh · Post by **adisheshu.dwh** » Wed Jan 07, 2009 5:41 am

HOW U MAINTAIN THE TIME DIFFERENCE IN TIME DIMENSION IF U HAVE DATA FROM INDIA AND US?

ArndW · Post by **ArndW** » Wed Jan 07, 2009 5:59 am

Once again, using all capitals is considered SHOUTING, and "U" might be valid on SMS messages but not in a professional forum such as this one.

A normal time field contains only a value and no GMT/UTC offset , if you need to account for this then you would need to add it. In some databases (Oracle comes to mind) you have a facility to convert time zones to and from UTC.

HSBCdev · Post by **HSBCdev** » Wed Jan 07, 2009 7:16 am

Interview... question... ?