Take the current date written various databases http://www.douzhe.com Author: CCBZZP Posted: 2003-07-08 07:13:10
Writing the current date to take various databases 1. ORACLE SELECT SYSDATE FROM DUAL 2. DB2 SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1 3. INFORMIX SELECT TODAY FROM TABLE 4. SQLSERVER SELECT GETDATE () FROM TABLE 5. SQLSERVER SELECT GETDATE () FROM TABLE 6. MYSQL mysql> select now (); mysql> select sysdate (); mysql> select curdate (); mysql> select current_date; mysql> select curtime (); mysql> select current_time; 7. FOXPRO select DATE () from TABLE Welcome everyone! [Posted Reply] [View CU Forum original post] [Close]
Soccer kid Reply to: 2003-07-08 08:17:15 So many database products, the landlord has been used, it is really admired! How to do in Access?
Project Reply to: 2003-07-08 09:47:34 can also use: values (current timestamp) in DB2
CCBZZP Reply to: 2003-07-08 10:52:32 [Quote: 6A37C430EB = "Football Kid"] So many database products, the landlord has been used, it is really admired! How to do in Access? [/ quote: 6A37C430EB]
Leo_WU Reply to: 2003-07-31 15: 54: 36dB2: "Current Date", Date Only "Current Time", Time Only "Current TimeStamp", TimeStamp Only Informix: "Today", Date Only; "TIME (CURRENT HOUR) To minute) ", HOR TO Minute;
SF2000 Reply to: 2003-08-04 14:01:14 Thank you! :)
SF2000 Reply to: 2003-08-04 14:03:45 Thank you! :)
MyMM Reply to: 2003-08-04 14: 21: 29SQL date and time function dayName Returns a case where the mixed string is returned. For the day part of the parameter, the name of this day is used in the week (for example, Friday). Dayofweek returns the week a day in the parameter, and the range of integers of 1-7 is represented in the Sunday. Dayofweek_iso Returns the week in the parameter, expressed in the range of 1-7 integral, where 1 is Monday. DayOfyear returns the first few days in the year in the parameter, expressed in the range of 1-366 integer value. Days return the full representation of the date. Julian_Day returns the number of days between January 1, 4712 (the beginning of the Confucian calendar) to the number of days between the specified date values in the parameter, and is expressed in an integer value. MidNight_Seconds Returns the second number between the time values specified in the midnight and parameters, indicating the integer value between 0 and 86400. Monthname returns a case-in-case mixed string (for example, January) for the month of the monthly part of the parameter. TimeStamp_ISO returns a timestamp value based on the date, time or timestamp parameters. TimeStamp_Format returns a timestamp from a string that has been interpreted using the character template. The timestampdiff returns the estimation time difference indicated by the type defined by the first parameter according to the time difference between the two time stamps. TO_CHAR Returns the character representation of the timestamp that has been formatted with the character template. TO_CHAR is synonymous with varchar_format. TO_DATE returns the timestamp from the string that has been interprected using the character template. TO_DATE is synonymous with TimeStamp_Format. WEEK returns a few weeks in the parameter in the first few years, expressed in the range of 1-54 integer value. The beginning of the week as a week. Week_ISO returns a few weeks in the parameter, expressed in the range of 1-53 integer values. mymm back in: 2003-08-04 14: 22: 38Example: YEAR (current timestamp) MONTH (current timestamp) DAY (current timestamp) HOUR (current timestamp) MINUTE (current timestamp) SECOND (current timestamp) MICROSECOND (current timestamp)
EJVN Reply to: 2003-09-30 11:31:08 Thank you very much!
