Subject | Date functions |
---|---|
Author | reinaldo_mra |
Post date | 2005-10-13T17:19:28Z |
I did not find any function to add a value to a timestamp column. I need
something like that:
SELECT * FROM Table WHERE TimeStampColumn<=AddMonth( NOW, 5)
SELECT * FROM Table WHERE TimeStampColumn<=AddDay( NOW, 5)
SELECT * FROM Table WHERE TimeStampColumn<=AddHour( NOW, 5)
The number 5 can be 5 days, 5 hours or 5 months. It depends on context.
Thanks,
[Non-text portions of this message have been removed]
something like that:
SELECT * FROM Table WHERE TimeStampColumn<=AddMonth( NOW, 5)
SELECT * FROM Table WHERE TimeStampColumn<=AddDay( NOW, 5)
SELECT * FROM Table WHERE TimeStampColumn<=AddHour( NOW, 5)
The number 5 can be 5 days, 5 hours or 5 months. It depends on context.
Thanks,
[Non-text portions of this message have been removed]