Questions on 'datetime' parameters

Dave Pfaltzgraff(at)PATAPSCO
01/29/2001 10:25 AM

I have a table defined as:

Table = associate
+---------------------+----------------------------------+-------+
| Field | Type | Length|
+---------------------+----------------------------------+-------+
| as_id | int4 not null | 4 |
| as_card | char() | 10 |
| as_end | datetime default ( now ( ) + 31 )| 8 |
+---------------------+----------------------------------+-------+

and would like to select entries where as_end is prior to the current
time. Which of the following would be the correct SQL statement?

SELECT AS_Card, AS_ID INTO ntemp FROM Associate WHERE AS_End < time('now');

or:

SELECT AS_Card, AS_ID INTO ntemp FROM Associate WHERE AS_End < 'now';

or, is there another form better... like maybe 'now'::datetime ...?

Thanks,
Dave