HOW U MAINTAIN THE TIME DIFFERENCE IN TIME DIMENSION IF U
Posted: Wed Jan 07, 2009 5:41 am
HOW U MAINTAIN THE TIME DIFFERENCE IN TIME DIMENSION IF U HAVE DATA FROM INDIA AND US?
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.