Results 1 to 2 of 2

Thread: Timezone

  1. #1
    Join Date
    Jun 2010
    Posts
    4

    Unanswered: Timezone

    Hi,

    This is my first post in this forum

    Please see the following Function i made

    Code:
    create or replace
    function convert_time ( datetime in timestamp, tz1 in varchar2, tz2 in varchar2 )
    return timestamp with time zone
    as
    	retval timestamp with time zone;
    begin	
    
    	retval := from_tz(datetime, tz1) at time zone tz2;
    	return retval;
    end;

    Do i have to do something extra to support Daylight savings time in specific region?

    Here wlile calling this function i am going to use builtin TZ_offset for timezones offset to be used inside function
    ex: TZ_OFFSET('US/Pacific').


    Kindly suggest

    Thanks
    Jack

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Do i have to do something extra to support Daylight savings time in specific region?

    No
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •