Re: Update column when datetime = NOW()
Posted by:
Trevor Pan
Date: February 20, 2020 10:37AM
Hi Peter,
Thank you.
Imagine you want a stack of lumber. You post a need for that lumber on a website and give 2 weeks for bidders to review the post and provide a price.
When the two weeks ends e.g.
deadline (column with time stamp) & current time = NOW()
the auction ends.
This causes the status (another column) to go from 0 (false) to 1 (true).
Now, no other bidder can bid on this job.
Hope this clarifies the need...
Subject
Written By
Posted
February 18, 2020 07:52AM
February 18, 2020 12:38PM
February 20, 2020 08:12AM
February 20, 2020 09:34AM
Re: Update column when datetime = NOW()
February 20, 2020 10:37AM
February 20, 2020 11:32AM
February 20, 2020 12:08PM
February 20, 2020 03:39PM
February 20, 2020 03:47PM
February 20, 2020 04:49PM
February 20, 2020 05:19PM
February 20, 2020 08:36PM
February 22, 2020 03:59PM
February 22, 2020 06:26PM
February 20, 2020 08:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.