[samigo-team] Need help on testing conversion script for SAM-1550
Karen Tsao
ktsao at stanford.edu
Fri Oct 12 16:47:40 PDT 2012
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/samigo-team/attachments/20121012/3be8454f/attachment.html
More information about the samigo-team
mailing list