<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!-- p { margin-top: 0px; margin-bottom: 0px; } @font-face { font-family: "Cambria Math"; } @font-face { font-family: Calibri; } @font-face { font-family: "Segoe UI"; } p.MsoNormal, li.MsoNormal, div.MsoNormal { margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; } a:link, span.MsoHyperlink { color: rgb(5, 99, 193); text-decoration: underline; } span.StileMessaggioDiPostaElettronica17 { font-family: Calibri, sans-serif; color: windowtext; } .MsoChpDefault { font-family: Calibri, sans-serif; } @page WordSection1 { margin: 70.85pt 2cm 2cm; } div.WordSection1 { }--></style>
</head>
<body dir="ltr" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi, <br>
</p>
<p><br>
</p>
<p> We use this<br>
</p>
<p><br>
</p>
<br>
<source><br>
<c:path>activation/validFrom</c:path><br>
</source><br>
<expression><br>
<script xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:c="http://midpoint.evolveum.com/xml/ns/public/common/common-3" xsi:type="c:ScriptExpressionEvaluatorType"><br>
<code><br>
import java.text.SimpleDateFormat; <br>
import java.text.DateFormat; <br>
DateFormat df = new SimpleDateFormat("yyyy-MM-dd");<br>
return df.format(com.evolveum.midpoint.util.MiscUtil.asDate(validFrom));<br>
</code><br>
</script><br>
</expression><br>
<condition><br>
<script xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:c="http://midpoint.evolveum.com/xml/ns/public/common/common-3" xsi:type="c:ScriptExpressionEvaluatorType"><br>
<code><br>
validFrom != null<br>
</code><br>
</script><br>
</condition><br>
<br>
<p><br>
</p>
<p><br>
</p>
<div id="Signature">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px"><font size="3"><b style="font-family:Times New Roman"><span style="font-size:10pt; color:rgb(31,73,125)">Paulo Fernandes de Souza Júnior</span></b><b style="font-family:Times New Roman"><span style="font-size:10pt; color:rgb(23,54,93)"></span></b><span style="font-family:Times New Roman">
</span><br style="font-family:Times New Roman">
<b style="font-family:Times New Roman"><span style="font-size:8pt; color:rgb(31,73,125)">NQPPPS<br>
</span></b><span style="font-size:8pt; font-family:Times New Roman; color:rgb(23,54,93)">Senado Federal -
</span></font><font size="3"><span style="font-size:8pt; font-family:Times New Roman; color:rgb(31,73,125)">PRODASEN<br>
</span><span style="font-size:8pt; font-family:Times New Roman; color:rgb(23,54,93)">Fone: 61 3303.3924</span></font><span style="color:rgb(31,73,125)"></span>
<br>
<br>
<p class="MsoNormal"><br>
</p>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="color: rgb(33, 33, 33);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>De:</b> midPoint <midpoint-bounces@lists.evolveum.com> em nome de Andrea Picconi via midPoint <midpoint@lists.evolveum.com><br>
<b>Enviado:</b> quinta-feira, 19 de novembro de 2020 13:42<br>
<b>Para:</b> midpoint@lists.evolveum.com<br>
<b>Cc:</b> Andrea Picconi; Marianna De Biasio; Jacopo Giuliano<br>
<b>Assunto:</b> [midPoint] Convert from gregorian calendar to Oracle Timestamp</font>
<div> </div>
</div>
<div>
<div class="WordSection1">
<p class="MsoNormal">Hi all,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span lang="EN-US">I need to convert a date format from gregorian calendar to Oracle Timestamp.</span></p>
<p class="MsoNormal"><span lang="EN-US">By now I’m using this script that does the opposite (inside an output mapping):</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:10.5pt; font-family:"Segoe UI",sans-serif"><expression><br>
<script xmlns:xsi="</span></i><i><span style="font-size:10.5pt; font-family:"Segoe UI",sans-serif"><a href="http://www.w3.org/2001/XMLSchema-instance%22" target="_blank" title="http://www.w3.org/2001/xmlschema-instance%22"><span lang="EN-US">http://www.w3.org/2001/XMLSchema-instance"</span></a></span></i><i><span lang="EN-US" style="font-size:10.5pt; font-family:"Segoe UI",sans-serif">
xmlns:c="</span></i><i><span style="font-size:10.5pt; font-family:"Segoe UI",sans-serif"><a href="http://midpoint.evolveum.com/xml/ns/public/common/common-3%22" target="_blank" title="http://midpoint.evolveum.com/xml/ns/public/common/common-3%22"><span lang="EN-US">http://midpoint.evolveum.com/xml/ns/public/common/common-3"</span></a></span></i><i><span lang="EN-US" style="font-size:10.5pt; font-family:"Segoe UI",sans-serif">
xsi:type="c:ScriptExpressionEvaluatorType"><br>
<code><br>
import java.text.SimpleDateFormat;<br>
import java.text.DateFormat;<br>
<br>
DateFormat dtf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");<br>
<br>
if (input!=null) {<br>
Date dt = dtf.parse(input);<br>
log.info("convertedValidFrom = " + dt);<br>
return com.evolveum.midpoint.util.MiscUtil.asXMLGregorianCalendar(dt);<br>
} else {<br>
return null;<br>
}<br>
</code><br>
</script><br>
</expression></span></i></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">How could I convert it to make it do the opposite?</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Regards,</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt">Andrea Picconi</span></b></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt">IAM (Identity Access Management)</span></i><span style="font-size:10.0pt"><br>
<br>
</span></p>
<p class="MsoNormal"><span lang="EN-US" style=""><img border="0" width="136" height="33" id="Immagine_x0020_1" alt="Innovery" style="width:1.4166in; height:.3437in" src="cid:image003.png@01D6BE9B.4322F0E0"></span><span style="font-size:10.0pt"><br>
Skype: precons</span><span style=""><br>
</span><span style="font-size:10.0pt">T: +39 06 51963439 (int. 196) <br>
</span><span style="font-size:12.0pt"><br>
</span><span style="font-size:10.0pt; color:black">Strada Quattro Palazzina A6 c/o Centro Direzionale Milanofiori, 20057 Assago (MI).<br>
</span><span style="font-size:10.0pt"><a href="http://www.innovery.net/"><span style="color:#0563C1">www.innovery.net</span></a> | T: +39 06 519 63 439</span><span style=""></span></p>
<p class="MsoNormal"> </p>
</div>
</div>
</div>
</body>
</html>