HI,
I have a timestamp field in the format as : yyyy-mm-dd hh24:mm:ss. Now I have another input field called MINUTES (Decimal (5,0)) and this field essentially contains values like 10,20,30... which are essentially number of minutes. I need to deduct this value from the timestamp field and put into an output field which is also an timestamp field. Kindly let me know how to achieve this.
Thanks in advance.
Duducting Some Minutes from a TIMESTAMP field
Moderators: chulett, rschirm, roy
You'll have to write your own. You may want to look here:
viewtopic.php?t=85788
to get a headstart. This function subtracts two timestamps. You basically have to subtract minutes and deal with rolling under hours and potentially days. Write a good function and post it for all to share! :D
viewtopic.php?t=85788
to get a headstart. This function subtracts two timestamps. You basically have to subtract minutes and deal with rolling under hours and potentially days. Write a good function and post it for all to share! :D
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Yup Boss. I will. Thanks for the help. Appreciate your help.
kcbland wrote:You'll have to write your own. You may want to look here:
viewtopic.php?t=85788
to get a headstart. This function subtracts two timestamps. You basically have to subtract minutes and deal with rolling under hours and potentially days. Write a good function and post it for all to share! :D