This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

How to remove minutes from current time?

Posted on 07-03-2024 09:07 AM
leinharte
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

Hi,

There is the column which type is a DateTime, and the initial value is now(). How to remove minutes from current time?

ex) 2024-07-03 15:33   =>   2024-07-03 15:00

Thanks.

Solved Solved
0 6 198
Topic Labels
Jump to Solution
0 Likes
Reply
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
jaichith
Gold 1
Gold 1
Reply posted on --/--/---- --:-- AM

DATETIME(
DATE(NOW()) & " " &
TEXT(HOUR(TIME(NOW()) - "00:00:00")) & ":00:00"
)

View solution in original post

Jump to Solution
Reply
6 REPLIES 6
Top Labels in this Space