date plus 90 days

Use the function date () to implement the displayed in the format: year-month-day hours: minutes: secRelated Time parameters:A-"AM" or "PM"A-"AM" or "PM"D-A few days, two digits, if less than two digits before the 0; such as: "01" to "31"D-Days of

Text functionsCHARCHAR: Returns the corresponding character according to the specified number. The Char function converts the numeric code of other types of computers to characters.Number: The digit that specifies the character, in 1Number: The

1, write the program, the user presses "YYYY-MM-DD" format to enter a date, the program after the output of the day is the days of the week, and calculated is the first day of the year. The following code is attached: Calculated week using the:

Oracle Date Subtraction2012-02-10 12:18--months_between (DATE2,DATE1)Give the month of date2-date1Sql> Select Months_between (' 1 September-December-1999 ', ' 1 September-March -1999 ') Mon_between from dual;Mon_between-----------9Sql>select

Transfer from http://hi.baidu.com/juanjuan_66/blog/item/cf48554c9331fbe6d62afc6a.htmlOracle Date Subtraction2012-02-10 12:18--months_between (DATE2,DATE1)Give the month of date2-date1Sql> Select Months_between (' 1 September-December-1999 ', ' 1

Http://blog.csdn.net/yjp198713/article/details/18131871oracle two minutes, hours of direct time.1, obtain the time difference millisecond number:Select Ceil ((to_date (' 2008-05-02 00:00:00 ', ' yyyy-mm-dd hh24-mi-ss ')-to_date (' 2008-04-30 23:59:59

---DQL: Data query statementsThe---Select statement must contain at least two words, namely the Select and from words.---the SELECT clause to specify the field to query.---the table that the FROM clause uses to customize the data source. The--select

Question: Enter a certain date of the year, Judge this day is the first days of the year. 1. Procedural analysis: Take March 5 as an example, should first add up the first two months, and then add 5 days, that is, the first days of this year,

JS get current date time and other operation summary 1 2 3 4 5 6 7 8 9 10 11 12 13-14 var mydate = new Date (); Mydate.getyear (); Gets the current year (2-bit) mydate.getfullyear (); Get the complete year (4-bit, 1970-????)

Common Date-type functions1.Sysdate Current date and timeSql> Select sysdate from dual;2.last_day last day of the monthSql> Select Last_day (sysdate) from dual;3.add_months (d,n) Current date d pushes n monthsUsed to increase or decrease some months