| Subject | Re: [firebird-support] How can I compare timeSpamp fields?... |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-11-23T00:55:05Z |
At 10:37 PM 22/11/2004 +0000, you wrote:
where MyTimestamp > '25.12.2003' (date or timestamp literal, in an
accepted format)
where MyTimestamp > MyTimestamp -10
where MyTimestamp > CURRENT_DATE - 30
where MyTimestamp > CURRENT_TIMESTAMP - 1
and so on...
./hb
>I have a field that records the date + time, ¿How can I compare ifwhere MyTimestamp > AnotherTimestamp
>Date +time > "x" in a query?
where MyTimestamp > '25.12.2003' (date or timestamp literal, in an
accepted format)
where MyTimestamp > MyTimestamp -10
where MyTimestamp > CURRENT_DATE - 30
where MyTimestamp > CURRENT_TIMESTAMP - 1
and so on...
./hb