Update Query to update the Date in Oracle table

Hi,

Can anyone please help me with the format that oracle support for updating the Date in oracle.

stmt = "Update Archival set Archived =2, Status=2, ArchivedDate=to_char(sysDate,'dd/mm/yyyy') where DocID =:A1"

status = Capi.Exec( cnct, stmt,node.pID)

i have even tried with below as well

status = Capi.Exec( cnct, "Update Archival set Archived =2, Status=2, ArchivedDate=to_char(sysDate,'dd/mm/yyyy HH:MI:SS') where DocID =:A1", node.pID)

Thanks,

Nirmala

Find more posts tagged with

Comments

Appu_Nair1

I don't think one writes oracle or sqlserver specific things for date as Oscript has a Date object.Its documentation has a myriad ways of representing a date.I attacha small snippet.Many times if you look at postings by such gurus as Chris Webster you will see him writing ANSI SQL to cover all databases.

Always parametrize,use bind variable,usr Str.Format or even in newer system you have an actual SQLstring object or so .Look in connect logs to see what your code supplied to the underlying database engine. You always have to write SQL that is not prone to SQL injection.SQLpackage and DBwizapi are also good reading material for you.

https://knowledge.opentext.com/knowledge/cs.dll/65969475/Date_Update_Using_CAPI.html?func=doc.Fetch&nodeid=65969475

Appu_Nair1

https://knowledge.opentext.com/knowledge/cs.dll/65969475/Date_Update_Using_CAPI.html?func=doc.Fetch&nodeid=65969475

sıɹɥɔ

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

Hi Nirmala,

Just as Appu suggests, because OScript has data types that map to database types you can use:

Capi.Exec( cnct, "Update Archival set Archived =2, Status=2, ArchivedDate=:A2 where DocID =:A1", node.pID, sysDate)

-chris

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Thursday, January 19, 2017 4:47 AM
To: eLink Recipient
Subject: Update Query to update the Date in Oracle table

Update Query to update the Date in Oracle table

Posted by Raghav, Nirmala On 01/19/2017 07:40 AM

Hi,Can anyone please help me with the format that oracle support for updating the Date in oracle.stmt = "Update Archival set Archived =2, Status=2, ArchivedDate=to_char(sysDate,'dd/mm/yyyy') where DocID =:A1"status = Capi.Exec( cnct, stmt,node.pID)i have even tried with below as wellstatus = Capi.Exec( cnct, "Update Archival set Archived =2, Status=2, ArchivedDate=to_char(sysDate,'dd/mm/yyyy HH:MI:SS') where DocID =:A1", node.pID) Thanks,Nirmala

sıɹɥɔ

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

Sorry I read your code quickly and assumed you had an OScript variable named "sysDate" that you wanted to use.

If instead you're wanting to use Oracle's sysdate value then the statement is simply:

Capi.Exec( cnct, "Update Archival set Archived =2, Status=2, ArchivedDate=sysdate where DocID =:A1", node.pID)

-chris

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Thursday, January 19, 2017 8:29 AM
To: eLink Recipient
Subject: RE Update Query to update the Date in Oracle table

RE Update Query to update the Date in Oracle table

Posted by Webster, Chris On 01/19/2017 11:26 AM

Hi Nirmala, Just as Appu suggests, because OScript has data types that map to database types you can use: Capi.Exec( cnct, "Update Archival set Archived =2, Status=2, ArchivedDate=:A2 where DocID =:A1", node.pID, sysDate) -chris
From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Thursday, January 19, 2017 4:47 AM
To: eLink Recipient
Subject: Update Query to update the Date in Oracle table

Update Query to update the Date in Oracle table

Posted by Raghav, Nirmala On 01/19/2017 07:40 AM

[To post a comment, use the normal reply function]
Topic:	Update Query to update the Date in Oracle table
Forum:	Content Server Development Forum
Content Server:	Knowledge Center CS16