Dave Pfaltzgraff@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