How to Replace the time

Sunilkumar3 — Fri, 15 Nov 2024 21:28:54 GMT

Hi Team,

Hope you are doing well. Team, I have a small issue Regarding the Date and Time. I have a date_time field in my data and I want to change the time. So, to do that. Please see the below Eg.

Eg.

Date_Time

2023-04-11 17:00:00

2023-04-12 17:00:00

2023-04-13 17:00:00

2023-04-3 12:30:00

Ans:

Date_Time

2023-04-11 16:00:00

2023-04-12 16:00:00

2023-04-13 16:00:00

2023-04-03 12:30:00

Re: How to Replace the time

Or — Thu, 17 Aug 2023 09:15:19 GMT

You've given no indication what logic you want to use to change the time...

Generally speaking, you can just use simple mathematical operators to modify datetime fields, e.g. Date_Time + (1/24) will add one hour.

topic Re: How to Replace the time in App Development

How to Replace the time

Re: How to Replace the time