This content has been marked as final. Show 2 replies
Just tried this on an Oracle env running on PT8.51 and it worked fine ...
&datetimevalue ="03-06-2009 05:52 PM";
&datetime = datetimevalue (&datetimevalue);
Are you sure this gives an error??
Being on DB2 should not affect PeopleCode functions, only at the moment of writing sql to the database ...
i am not directly assigned this value to &datetimevalue. Date value dynamically assigned to array(array of any). Then i fetched date value from the array and assigned to &datetimevalue variable.
i will show you some sample code of my project.
* Local JavaObject &JavaFileArray = CreateJavaArray("java.lang.Object", &JFileList.length);
&JavaFileArray = &JFileList;
&FileNames [&JavaFileArray.length] = Null;
For &I = 1 To &FileNames.Len
If Len(RTrim(&FileNames [&I])) > 0 Then
&DateTimeStamp = " ";
&FileSize = " ";
&FileName = " ";
&FileData = CreateArray("");
&FileData = Split(&FileNames [&I], "|");
&DateTimeStamp = &FileData ;
&FileSize = LTrim(&FileData );
&FileName = &FileData ;