AnsweredAssumed Answered

How to display full current date time?

Question asked by clarityeur on Aug 12, 2013
Latest reply on Aug 14, 2013 by clarityeur
Hello Guys,

Clarity 13.1 / MSSQL

I have a custom attribute (data type 'Date') using option 'Current Date Time', this attribute is updated through Gel-Script simple statement using GETDATE()

The process is executed correctly, but in the attribute appears MM/DD/YYYY, but I need to show full path (including Hour/Minute/Seconds), using this format:

YYYY-MM-DD HH:MM:SS

Please check this screen shots as reference

My custom script is:

<gel:script xmlns:j="jelly:core"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
xmlns:sql="jelly:sql"
xmlns:core="jelly:core">

<core:set var="v_projectid" value="${gel_objectInstanceId}"/>

<gel:setDataSource dbId="niku"/>
<gel:log level="DEBUG" category="PROCESS">Processing : ${v_projectid}</gel:log>
<sql:update>
UPDATE ODF_CA_PROJECT
SET custom_date = getdate()
FROM INV_INVESTMENTS
WHERE INV_INVESTMENTS.id = ODF_CA_PROJECT.id
AND INV_INVESTMENTS.id = '${v_projectid}'
</sql:update>

</gel:script>

Thanks you

Attachments

Outcomes