Date taking 1 day back in Poratl2

Flow Classic
,
1

Hi ,

I’m observing a stage behaviour like below in Poratl2.

  • Once I do a adte insertion through screen in Poratl2, it takes current date

  • But again if I want to update same date field to anothe it takes one day after

e.g. previous date entry 12-01-2015

Took a date 11-01-2015 for update using date field calender

In DB it’s updating as 10-01-2025

Oracle DB column type is DATE field

Any idea about this?

BR,

Bhaskar

2

It is a timezone issue. Oracle date datatype is not timezone aware, but if you have timezone enabled in the portal you will send the date and time with the timezoneoffset, which will be one date earlier in Oracle.

Try to turn it off:

3

Hi Ola,

Thanks for teh reply.

To me this was working without any issue upto yesterday and now it’s happening.

Can you please let me know what I need to reset or turn off so that I can say the same to server/DB team.

BR,

Bhaski

4

Hi Ola,

You’re genius, I switchedd off teh OFFSET in portal2, it’s workin.

But please let me know what settings I should enquire with DB/Server team that they changed because it was ON upto yesterday and last 2 days issue vame.

BR,

Bhaski

5

Glad to hear. I think it was more of a coincidence that the time part was inside the difference in hours between the client’s timezone and UTC, or something like that. Did you switch between daylight saving time or something similar?
In oracle the “Date” datatype does not contain the offset part, so it should not have been a setting on the DB (unless they moved from Date to DateOffset (or it is called something like that) as a data type for the columns, but that seem strange)