informix date functions

Setting Informix Environment Variables I. Environment exampleVariable Name DescriptionDBDELIMITER specifies the field delimiters used by dbload in the extract data file.DBDATE specifies the date format (Y4MD/, MDY4-) to be used in the database

Oracle basic concepts and comparison with informix I. ConceptsUser: informix directly uses the user management system of the operating system. Generally, root and informix are used as super operators to manage other users. Oracle has its own user

I. Intrinsic functions1. Internal aggregate function1) Count (*) returns the number of rows2) Count (DISTINCT colname) returns the number of unique values in the specified column3) SUM (colname/expression) Returns the value of the specified column

Function Detailed usage of Informix SQL functions One, internal functions 1. Internal aggregate function 1) Count (*) returns the number of rows 2 count (DISTINCT colname) returns the number of unique values in the specified column 3) SUM

I. Introduction 1) INFORMIX consists of three main products: Database Server (Database Core) Application development tools Network Database interconnection Products 2) The database server provides two functions: Data Operations and Management:

Source: http://dev.csdn.net/article/60/60822.shtm Detailed usage of Informix SQL Functions I. Internal functions1. Internal Aggregate functions1) count (*) returns the number of rows2) count (distinct colname) returns the number of unique values in

Aggregate functions:AVG, calculate the average valueCount, count the number of recordsMax, calculate the maximum valueMin, minimum valueRange: calculates the difference between the maximum and minimum values of the selected row.STDev: calculates the

PHP Function Index 967 functions A total of 967 functions Abs: Get absolute value. Acos: Gets the inverse cosine value. Ada_afetch: Gets the return column of the database. Ada_autocommit: Switch automatic change function. Ada_close: Close Adabas D

Detailed articles on select, showing raw data, SQL, query results, and how SQL should be written under different databases.Https://en.wikipedia.org/wiki/Select_ (SQL)The directory is as follows:Contents [Hide]1Examples2limiting result

Original ENGLISH Development object-relational database applicationProgram(Part 1) Paul BrownIBM InformixJune 2002   content