PHP MySql Web Hosting

PHP and MySQL Web Development

,ch04.13730 Page 193 Wednesday, November 29, 2000 4:43

Filed under: SQL in a Nutshell — webmaster @ 8:19 pm

,ch04.13730 Page 193 Wednesday, November 29, 2000 4:43 PM Table 4-10: PostgreSQL Supported Functions (continued) Function position(string in string) pow(float8,float8) popen(path) reltime(interval) radians(float8) radius(circle) round(float8) rpad(text,int,text) rtrim(text,text) sin(float8) sqrt(float8) substring(string [from int] [for int]) substr(text,int[,int]) tan(float8) text(char) text(varchar) textpos(text,text) timestamp(date) timestamp(date,time) to_char(timestamp, text) to_char(int, text) to_char(float, text) to_char(numeric, text) to_date(text, text) to_number(text, text) to_timestamp(text, text) translate(text,from,to) trim([leading|trailing| both] [string] from string) trunc(float8) upper(text) varchar(char) varchar(text) width(box) Description Returns location of specified substring Raises a number to the specified exponent Converts path to open path Converts to reltime Converts degrees to radians Returns radius of circle Rounds to nearest integer Converts right pad string to specified length Converts right trim characters from text Returns sine Returns square root Extracts specified substring Extracts specified substring Returns tangent Converts char to text type Converts varchar to text type Locates specified substring Converts to timestamp Converts to timestamp Converts timestamp to string Converts int4/int8 to string Converts float4/float8 to string Converts numeric to string Converts string to date Converts string to numeric Converts string to timestamp Converts character in string Trims characters from string Truncates (towards zero) Converts text to uppercase Converts char to varchar type Converts text to varchar type Returns horizontal size Functions Vendor Extensions 193

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost PHP MySQL Web Hosting services

No Comments

No comments yet.

RSS feed for comments on this post. TrackBack URI

Sorry, the comment form is closed at this time.

Powered by PHP MySQL Web Hosting