[Building Sakai] Need help on testing conversion script for SAM-1550

[Karen Tsao]

Hi,

If you use Oracle db and have SAM-998 applied to your instance, can you
please help with verifying the conversion scripts for
https://jira.sakaiproject.org/browse/SAM-1550? Here is the Oracle script:

            -- Apply the following two queries only if you have SAM-988 in
your instance
            -- Change the date format from:
            -- Wed Sep 14 11:40:53 CDT 2011 (output of Date.toString() in
SAM-988)
            -- to:
            -- 2012-08-23T10:59:34.180-05:00 (ISO8601 format in SAM-1550)
            -- Please make the corresponding time zone changes to the
queries:
            update SAM_SECTIONMETADATA_T
            set entry = TO_CHAR(to_timestamp_tz(entry, 'DY MON DD
HH24:MI:SS TZD YYYY'),'YYYY-MM-DD')
            || 'T'
            || TO_CHAR(to_timestamp_tz(entry, 'DY MON DD HH24:MI:SS TZD
YYYY'),'HH24:MI:SS')
            || '.000'
            || TO_CHAR(to_timestamp_tz(entry, 'DY MON DD HH24:MI:SS TZD
YYYY'),'TZH:TZM')
            where label='QUESTIONS_RANDOM_DRAW_DATE';

            update SAM_PUBLISHEDSECTIONMETADATA_T
            set entry = TO_CHAR(to_timestamp_tz(entry, 'DY MON DD
HH24:MI:SS TZD YYYY'),'YYYY-MM-DD')
            || 'T'
            || TO_CHAR(to_timestamp_tz(entry, 'DY MON DD HH24:MI:SS TZD
YYYY'),'HH24:MI:SS')
            || '.000'
            || TO_CHAR(to_timestamp_tz(entry, 'DY MON DD HH24:MI:SS TZD
YYYY'),'TZH:TZM')
            where label='QUESTIONS_RANDOM_DRAW_DATE';


Thanks in advance.
Karen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20121012/3be8454f/attachment.html