topic RE: Hello in Product Forum

Hello

theBelovedKing — Sat, 03 Jun 2023 13:07:00 GMT

Hello everyone!

My name is Kingsley David, and this is a succinct bio about me.

-Current role: RPA Developer
-Where you're currently based: Nigeria
-Background in RPA/Tech: Blue Prism is my very first engagement with RPA, which is turning out to be long-lasting sweet relationship (smile). My background is in Engineering, with IT Support being one of my natural breadths of fresh air 😊, dating back to the first time I saw those wonderful boxes called computer. Ever since then, it's been an unbroken bond, with new discoveries made at regular intervals.
-Why you joined the BP Community: It is the perfect place to grow my knowledge in RPA and Blue Prism, engage in collaborative work and intuitive conversations, network and get direct feedback from leading experts!

I am already excited as I embark on this journey to building secure and intelligent systems/applications.

------------------------------
------------------------------
Kingsley M. D. David
------------------------------
------------------------------

RE: Hello

steven.boggs — Tue, 06 Jun 2023 13:26:00 GMT

Welcome to the Blue Prism Community, Kingsley!

I hope you can find some useful information here to help you along your RPA journey. Please don't hesitate to ask questions if you have them.

------------------------------
Steve Boggs
Senior Product Support Engineer
Blue Prism
Austin, TX
------------------------------

RE: Hello

theBelovedKing — Wed, 07 Jun 2023 18:57:00 GMT

Thank you Steve.

I am pleased to be here.

For a start, please, each time I run this query in Oracle SQL Developer SELECT TRUNC(SYSDATE) FROM DUAL, I get the actual date i.e., today's date (07-JUN-2023)

However, when I execute the same script in Blue Prism using Blue Prism Oracle MDA VBO (which I downloaded from Digital Exchange), my date is a day behind (i.e., 06-JUN-2023).

Please, what might be the challenge? And how can I fix it?
Thanks

------------------------------
Kingsley David
------------------------------

RE: Hello

AndrewPascal — Tue, 13 Jun 2023 14:58:00 GMT

Hi Kingsley,

I suspect it might be time-zone related. TRUNC(SYSDATE) will return 07-JUN-2023. I'm guessing that the VBO will return this to Blue Prism as 2023-06-07 00:00:00. Because your local time zone is UTC+1, this may be converted back into UTC before you see it - which would be 2023-06-06 23:00:00.

What happens if you SELECT SYSDATE FROM DUAL? Do you get local datetime in SQL Developer, but UTC datetime from Blue Prism? If so, that's the reason for your discrepancy.

Hope this helps,

Andrew Pascal

------------------------------
Andrew Pascal
------------------------------

RE: Hello

theBelovedKing — Tue, 13 Jun 2023 17:06:00 GMT

Hello Andrew Pascal,

Thanks for your response.
SELECT SYSDATE FROM DUAL gives me local date time in SQL developer but UTC in Blue Prism.

The solution I implemented was converting it to CHAR and spooling into Blue Prism i.e. TO CHAR (TRUNC (SYSDATE ), 'DD-MM-YYYY' DATE_CREATED). This relieves me of additional conversions in Blue Prism, as the date is retained.

Thanks

------------------------------
Kingsley David
------------------------------

RE: Hello

AndrewPascal — Wed, 14 Jun 2023 07:38:00 GMT

Just what I was going to suggest! Glad you've got it working now.

Kind regards,

Andrew Pascal

------------------------------
Andrew Pascal
------------------------------