FAQ
I need some help to convert a GMT date into PST date and take care of all Day
Light saving etc. Is there any pre-built function or easy way of doing it. My
database version is 8i ( 8.1.7.4)

Thanks
Manmohan

Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Anubha Jalsingh
INET: ajalsingh_at_lycos.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • AK at Aug 12, 2003 at 11:59 pm
    select new_time(sysdate,'GMT','PST') from dual;

    -ak

    Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Tuesday, August 12, 2003 4:39 PM
    I need some help to convert a GMT date into PST date and take care of all Day
    Light saving etc. Is there any pre-built function or easy way of doing it. My
    database version is 8i ( 8.1.7.4)

    Thanks
    Manmohan



    ____________________________________________________________
    Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
    http://login.mail.lycos.com/r/referral?aid=27005
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Anubha Jalsingh
    INET: ajalsingh_at_lycos.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: AK
    INET: oramagic_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 12, '03 at 11:39p
activeAug 12, '03 at 11:59p
posts2
users2
websiteoracle.com

2 users in discussion

AK: 1 post Anubha Jalsingh: 1 post

People

Translate

site design / logo © 2021 Grokbase