You are asking for trouble. Timestamps are designed for change referances
on records, and may not even be anything that resembles time (look at
oracle and M$SQL). Their purpose is not to give an end user what time the
record has been updated, but to tell if the record HAS been updated at all.
Although you can find a solution for MySQL, be aware that you have just
locked yourself into MySQL. It's not portable, it could change at any time,
it is not good.
At 04:16 PM 6/3/99 -0700, you wrote:
>Hi all,
>
>I need to do something like:
>
> select * from tblname where timestamp+14 <= '1999-06-30'
>
>Any suggestions? TIA.
>
>Regards, -Lew
>
>
>
>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail win32-thread135@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail win32-unsubscribe@stripped instead.
>
>
---
Peter B. Carter (peterc@stripped)
Pager: 613-751-4660
http://www.pbc.ottawa.on.ca
