whereclause and timestamp 
Author Message
 whereclause and timestamp

Hi!

I must select * from a table where last update is between last friday and
mondaymorning. How can I solve it with timestamp or something like
that? Is there a way to convert the timestamp-binary to date?

Thanks...

OOOO SSSS L    Andreas Gerler                   Phone: +49-4221-9420-73, Fax: -27
O  O S    L    OSL Online Software Labor GmbH   Homepage: http://www.***.com/

O  O    S L    27777 Ganderkesee                and mailto:42(at)net27.de (max. 160 Chars)
OOOO SSSS LLLL



Fri, 14 Feb 2003 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Can you use Date_time timestamp columns for Whereclause

2. docmd.openform and WhereClause?

3. whereclause - colname in (null,"s")

4. left outer joins with a whereclause seem to not work correctly

5. TSQL 7.0, More limiting whereclause reduces # returned rows

6. Problem with translate function in whereclause.

7. When Timestamp is not Timestamp -- How to Fix

8. BUG?: timestamp without TZ created as timestamp *with*

9. BUG?: timestamp without TZ created as timestamp *with* TZ

10. BUG?: timestamp without TZ created as timestamp

11. timestamp use ; timestamp conversions

12. create a table with default timestamp as current timestamp + 100 days


 
Powered by phpBB® Forum Software