|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|||||||||||||||||
|
|
||||||||
|
|||||||||
|
|
|
|
Company
|
|
 SQL LINKS DEVELOPER SUPPORT
SEARCH Borland Online/Developer Support
DATE HANDLING USING INTERBASE 4:
SELECT ORDER_NO, CUSTOMER_NO, SALE_DATE FROM ORDERS
WHERE (SALE_DATE LIKE "%25-MAY%")
SELECT ORDER_NO, CUSTOMER_NO, SALE_DATE FROM ORDERS
WHERE (SALE_DATE BETWEEN "1-MAY-88" AND "1-JUN-88")
(SQL INSTANT REFERENCE page 144)
SELECT ORDER_NO, CUSTOMER_NO, SALE_DATE FROM ORDERS
WHERE SALE_DATE = (CAST('12-JUN-88' AS DATE))
(LIBS DATA DEFINITION GUIDE page 65)
PUB
IB ANY TECH
BC
|
|
||
|
|
|
|||
|
|||||
|
|
||||
 |
|||||
|
|||||
| Made in Borland® Copyright© 1994-2003 Borland Software Corporation. All rights reserved. Report Piracy, Legal Notices, Privacy Policy Last Modified Monday, 26-Mar-2001 16:27:06 PST |
|||||
