> 1. Yaffil SQL > date as integer -- ×ÏÚ×ÒÁÝÁÅÔ ËÏÌÉÞÅÓÔ×Ï > ÄÎÅÊ. ËÏÌÉÞÅÓÔ×Ï ÞÅÇÏ, ÐÒÏÓÔÉÔÅ? ÄÎÅÊ? Á ÍÏÖÎÏ ÕÔÏÞÎÉÔØ, ÄÎÅÊ × ÇÏÄÕ, ÉÌÉ ÄÎÅÊ ÓÕÝÅÓÔ×Ï×ÁÎÉÑ ×ÓÅÌÅÎÎÏÊ? :)
> 2. MSSQL > ÁÎÁÌÏÇÉÞÎÏ: > http://vyaskn.tripod.com/searching_date_time_values.htm ÎÅ ÞÉÔÁÌ. ÎÅ ÉÎÔÅÒÅÓÎÏ. > 3. Oracle > ÃÉÔÁÔÁ: "Date Arithmetic > You can add and subtract number constants as well as other dates from > dates. Oracle interprets number constants in arithmetic date > expressions as numbers of days. For example, SYSDATE + 1 is tomorrow. > SYSDATE - 7 is one week ago. SYSDATE + (10/1440) is ten minutes from > now. Subtracting the hiredate column of the sample table employees from > SYSDATE returns the number of days since each employee was hired. You > cannot multiply or divide DATE values." ÄÙË × ÐÔÉÞËÅ ÔÏ ÖÅ ÓÁÍÏÅ. ÓÔÒÁÎÎÏ, ÄÁ? ÜÔÏ ÐÒÏ ÁÒÉÆÍÅÔÉÞÅÓËÉÅ ÏÐÅÒÁÃÉÉ.. > 4. PostgreSQL > ÃÉÔÁÔÁ: > "Q. Where are the DATEADD and DATEDIFF functions in PostgreSQL? > A. There are none. PostgreSQL does not need them. Use the + and - > operators instead. " É ÜÔÏ ÐÒÏ ÁÒÉÆÍÅÔÉÞÅÓËÉÅ ÏÐÅÒÁÃÉÉ. ÐÒÉÂÁ×Ø × ÐÔÉÞËÅ Ë current_date ÅÄÉÎÉÞËÕ É ×ÏÚÒÁÄÕÊÓÑ. "ÚÁ×ÔÒÁ" ÂÕÄÅÔ :) > 5. IBM DB2 > http://www.thescripts.com/forum/thread183738.html ÐÒÏÓÔÉ, ÎÅ ÞÉÔÁÌ. > 6. MySQL. > ó ÄÁÔÁÍÉ ÍÏÖÎÏ ÒÁÂÏÔÁÔØ ËÁË Ó ÃÅÌÙÍÉ > ÞÉÓÌÁÍÉ, ÔÏÌØËÏ ÜÔÏ ÎÅ ËÏÌÉÞÅÓÔ×Ï ÄÎÅÊ, > Á ÂÕË×ÁÌØÎÏÅ ÐÒÅÄÓÔÁ×ÌÅÎÉÅ ÓÔÒÏËÉ > ÄÁÔÙ. ÎÁÐÒÉÍÅÒ, ÃÅÌÏÞÅ ÞÉÓÌÏ 20061204 -- > ÏÚÎÁÞÁÅÔ '2006-12-04'. ÈÍ.. ÎÁ×ÓËÉÄËÕ Ú×ÕÞÉÔ ÓÔÒÁÛÎÏ. ÕÖ ÌÕÞÛÅ ÂÙ ÜÔÏ ÂÙÌÏ ËÏÌÉÞÅÓÔ×Ï ÄÎÅÊ Ó òÏÖÄÅÓÔ×Á èÒÉÓÔÏ×Á, ÅÓÌÉ ÄÒÕÇÉÈ ×ÁÒÉÁÎÔÏ× ÎÁ×ÓËÉÄËÕ ÎÅÔ.. Á ÔÅÐÅÒØ "ÍÙ ÐÏ×ÔÏÒÑÅÍ ÎÁÛ ÎÏÍÅÒ!". ËÏÌÉÞÅÓÔ×Ï ÄÎÅÊ - ×ÓÅÇÄÁ ÏÔÎÏÓÉÔÓÑ Ë ÉÎÔÅÒ×ÁÌÕ. ÏÄÉÎ ËÏÅà ÉÎÔÅÒ×ÁÌÁ ÔÙ ÚÁÄÁÌ - ÜÔÏ ÎÅËÉÊ ÐÁÒÁÍÅÔÒ. Á ×ÔÏÒÏÊ? ÔÙ ÍÎÅ ÓËÁÖÉ, Ó ËÁËÏÇÏ ÄÎÑ ÔÅÂÅ ËÏÌÉÞÅÓÔ×Ï ÄÎÅÊ ÎÁÄÏ? ÅÓÌÉ Ó ÔÒÅÔØÅÇÏ Á×ÇÕÓÔÁ ×ÏÓØÍÉÄÅÓÑÔÏÇÏ ÇÏÄÁ, ÔÏ É ÉÓÐÏÌØÚÕÊ ×ÅÚÄÅ ËÏÎÓÔÒÕËÃÉÀ :p_date-cast('1980-08-03' as date). ÜÔÏ É ÅÓÔØ ËÏÌÉÞÅÓÔ×Ï ÄÎÅÊ. ËÕ?