1 Reply Latest reply: Apr 15, 2014 9:18 AM by fac586 RSS

    What date format using .ics

    SAYYED

      Hi

       

      can any one suggest me what date/time format using in .ics and what function do i need use to achieve the same format from sysdate(or any of the date column).

       

      I have check the below appended ics file and i am not understanding how to provide such time format(DTEND:20140401T170000Z) and what format type it used.

       

      BEGIN:VCALENDAR

      PRODID:-//Microsoft Corporation//Outlook 12.0 MIMEDIR//EN

      VERSION:2.0

      METHOD:PUBLISH

      X-MS-OLK-FORCEINSPECTOROPEN:TRUE

      BEGIN:VEVENT

      CATEGORIES:EDUCATION

      CLASS:PUBLIC

      CREATED:20140415T125739Z

      DESCRIPTION:Go to http://oukc.oracle.com/static09/opn/login/?t=livewebcast|

          c=1467712042 to attend\n

      DTEND:20140401T170000Z

      DTSTAMP:20140415T125739Z

      DTSTART:20140401T160000Z

      LAST-MODIFIED:20140415T125739Z

      LOCATION:Live Webcast

      PRIORITY:5

      SEQUENCE:0

      SUMMARY:Research Management System and Fusion23456

      TRANSP:OPAQUE

      UID:uid-38893C00F42F38A1E0404498C8A6612B0007F89AED0A

      X-ALT-DESC;FMTTYPE=text/html:<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//E

          N">\n<HTML>\n<HEAD>\n<META NAME="Generator" CONTENT="MS Exchange Server ve

          rsion 08.00.0681.000">\n<TITLE></TITLE>\n</HEAD>\n<BODY>\n<!-- Converted f

          rom text/plain format -->\n\n<P><FONT SIZE=2>Go to <A HREF="http://oukc.or

          acle.com/static09/opn/login/?t=livewebcast|c=1467712042">http://oukc.oracl

          e.com/static09/opn/login/?t=livewebcast|c=1467712042</A> to attend</FONT>\

          n</P>\n\n</BODY>\n</HTML>

      X-MICROSOFT-CDO-BUSYSTATUS:BUSY

      X-MICROSOFT-CDO-IMPORTANCE:1

      X-MICROSOFT-DISALLOW-COUNTER:FALSE

      END:VEVENT

      END:VCALENDAR

       

      Thanks and regards,

      Ibrahim Sayyed.

        • 1. Re: What date format using .ics
          fac586

          SAYYED wrote:

           

          can any one suggest me what date/time format using in .ics and what function do i need use to achieve the same format from sysdate(or any of the date column).

           

          I have check the below appended ics file and i am not understanding how to provide such time format(DTEND:20140401T170000Z) and what format type it used.

           

          BEGIN:VCALENDAR

          PRODID:-//Microsoft Corporation//Outlook 12.0 MIMEDIR//EN

          VERSION:2.0

          METHOD:PUBLISH

          X-MS-OLK-FORCEINSPECTOROPEN:TRUE

          BEGIN:VEVENT

          CATEGORIES:EDUCATION

          CLASS:PUBLIC

          CREATED:20140415T125739Z

          DESCRIPTION:Go to http://oukc.oracle.com/static09/opn/login/?t=livewebcast|

              c=1467712042 to attend\n

          DTEND:20140401T170000Z

          DTSTAMP:20140415T125739Z

          DTSTART:20140401T160000Z

          LAST-MODIFIED:20140415T125739Z

          LOCATION:Live Webcast

          PRIORITY:5

          SEQUENCE:0

          SUMMARY:Research Management System and Fusion23456

          TRANSP:OPAQUE

          UID:uid-38893C00F42F38A1E0404498C8A6612B0007F89AED0A

          X-ALT-DESC;FMTTYPE=text/html:<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//E

              N">\n<HTML>\n<HEAD>\n<META NAME="Generator" CONTENT="MS Exchange Server ve

              rsion 08.00.0681.000">\n<TITLE></TITLE>\n</HEAD>\n<BODY>\n<!-- Converted f

              rom text/plain format -->\n\n<P><FONT SIZE=2>Go to <A HREF="http://oukc.or

              acle.com/static09/opn/login/?t=livewebcast|c=1467712042">http://oukc.oracl

              e.com/static09/opn/login/?t=livewebcast|c=1467712042</A> to attend</FONT>\

              n</P>\n\n</BODY>\n</HTML>

          X-MICROSOFT-CDO-BUSYSTATUS:BUSY

          X-MICROSOFT-CDO-IMPORTANCE:1

          X-MICROSOFT-DISALLOW-COUNTER:FALSE

          END:VEVENT

          END:VCALENDAR

          iCalendar uses the ISO 8601 standard for representing date and time data. The equivalent Oracle date/time format mask is YYYYMMDD"T"HH24MISS"Z" (assuming the date/time value is UTC. If it is not, then convert the date/time value to UTC before applying the ISO 8601 format mask):

           

          SQL> select

            2      systimestamp

            3    , to_char(systimestamp, 'YYYYMMDD"T"HH24MISS"Z"') iso8601

            4    , to_char(sys_extract_utc(systimestamp), 'YYYYMMDD"T"HH24MISS"Z"') utc_iso8601

            5  from

            6      dual;

           

          SYSTIMESTAMP                             ISO8601          UTC_ISO8601

          ---------------------------------------- ---------------- ----------------

          15-APR-2014 10:13:55.878580 -04:00       20140415T101355Z 20140415T141355Z