active workflows via email

[SalihAkcaoglu607581]

Hi, 

i will send daily at 6.15 am the following details per email: 

-active workflows between 0.00am - 06.00 am
-startime of the workflow

result:

i only get the start date of the workflow. :/
How can i get the starttime of the workflow (oracle database)?

Thanks in advance. 


Best regards
Salih

[Frank Muffke]

Hi

thats a setting in your local ORA client somewhere on NLS section.
Sry I am no oracle expert by far so no idea which one it is  exactly :-(

I have the same behavior using an SQLI VARA (time included) and Oracle SQL developer (date only) 

hope this helps a bit.

cheers, Wolfgang

------------------------------
Support Info:
if you are using one of the latest version of UC4 / AWA / One Automation please get in contact with Support to open a ticket.
Otherwise update/upgrade your system and check if the problem still exists.
------------------------------

[Pete Wirfs]

I think EJPP_StartTime needs to be wrapped with a function like so;

to_char(EJPP_StartTime,'mm-dd-yyyy hh24.mi.SS') as StartTime

And note it is stored in GMT, so you may also want to adjust it for that too.  (I know how to do this in SQLServer, but I don't know how to do this in Oracle.)

EDIT:
The Oracle function that can convert timestamps to different time zones is NEW_TIME()

------------------------------
Pete
------------------------------

[Carsten Schmitz]

​Or try this. This is how I get usable time stamps from Automic tables on Oracle:

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-RR HH24:MI:SS';

Hth,

[SalihAkcaoglu607581]

It works! Thank you :)