[Resolved] getDate

[moboter]

The problem I encountered is as follows:
I have a Date field in a mysql table I now want to perform a calculation based on this field with the current date
deduct the date stored in the table from the current date and return an integer value.
I know that I can get the integer value of the current date with getDate but how do I get the value for the stored date?😕

[steadyguy]

Suppose the column in your table (called 'my_table') is called 'my_date', try this:

SELECT my_date, CURDATE() - my_date
FROM my_table

This will give you the difference, in days, between today's date, and the date stored in my_date, negative being in the future.

If the column is a DATETIME column, replace CURDATE() with NOW(), and your results will be in seconds.

[moboter]

Thank you for your quick reply. Works fine.