Delphi. 11


         


, , InterBase. , , . InterBase, , . , SQL, InterBase, , . InterBase . , :

¨    October 27, 1995

¨    27-OCT-1994

¨    10-27-95

¨    10/27/95

¨    27.10.95

, SQL- :

à      yesterday

à      today

à      now ( )

à      tomorrow

( ), :

-     , , ;

-     .

SELECT first_name, last_name, hire_date

FROM employee

WHERE hire_date > '1-1-94' ,

1 1994

FIRST_NAME LAST_NAME HIRE_DATE

=============== ==================== ===========

Pierre Osborne 3-JAN-1994

John Montgomery 30-MAR-1994

Mark Guckenheimer 2-MAY-1994

, , .

SELECT first_name, last_name, hire_date

FROM employee

WHERE 'today' - hire_date > 365 * 7 + 1
,


7

FIRST_NAME LAST_NAME HIRE_DATE

=============== ==================== ===========

Robert Nelson 28-DEC-1988

Bruce Young 28-DEC-1988