Results 1 to 14 of 14
Jan 19, 2010, 13:44 #1
- Join Date
- Sep 2006
- 0 Post(s)
- 0 Thread(s)
SQL cell formula possible? Possibly a dumb question...
I have two cols in a MySQL database date1 and date2.
I need a third col that needs to be: time = date2 - date1
Rather than having to perform this operation with a select calculate and insert statement I was wondering if there was a way to put a formula of some sort in the time col that would automatically calculate the difference in the dates?
I guess the closest real-world example I can provide is something similar to what you could do in Excel with formulas and equations.
*Disclaimer: this is my first venture into MySQL math
Thanks in advance for any guidance!