by Dinesh Thakur Category: Servlet with MySql Database

The function 'HOUR' will show the current Hour of system.

 
by Dinesh Thakur Category: Servlet with MySql Database

This Function will return the HEXA DECIMAL value of a number.

 
by Dinesh Thakur Category: Servlet with MySql Database

This function will return the value that greater from other number or expression.

 
by Dinesh Thakur Category: Servlet with MySql Database

This function will show that the greater Number Between Two expressions.

 
by Dinesh Thakur Category: Servlet with MySql Database

This function will show that the expression is greater equal or not with other expression.

 
by Dinesh Thakur Category: Servlet with MySql Database

This function will use to get the desired Date Format.

 
by Dinesh Thakur Category: Servlet with MySql Database

This Function will Converts a day number to a Date.

 
by Dinesh Thakur Category: Servlet with MySql Database

This function will provide the formatted value of expression with decimal place.

 
by Dinesh Thakur Category: Servlet with MySql Database

This Function will Returns the largest integer value that is not Greater than passed numeric expression.

 
by Dinesh Thakur Category: Servlet with MySql Database

The Function 'FIELD' will return the position of the first argument.

 
by Dinesh Thakur Category: Servlet with MySql Database

This function will extract the Date.

 
by Dinesh Thakur Category: Servlet with MySql Database

The function 'Export Set' will return the string such that for every bit set in the value bits.

 
by Dinesh Thakur Category: Servlet with MySql Database

This function will return the natural base of logarithm (e).

 
by Dinesh Thakur Category: Servlet with MySql Database

This function will show that the expression value’s are Equal or Not.

 
by Dinesh Thakur Category: Servlet with MySql Database

This function 'ELT' will return the String at index Number.

 
by Dinesh Thakur Category: Servlet with MySql Database

This function will also return the divided value from two expressions with a sign of division (/).

 
by Dinesh Thakur Category: Servlet with MySql Database

This function will return divided value from two expressions. The first i made a database named 'dbase' within the reference of mySql(php myAdmin). Then after i import all java packages from java library as program need. Here i made a class named 'MySqlDIVFunction' which extends 'HttpServlet'.i use service()Method that will help to getting the request from doGet()Method for output on web browser.



 
by Dinesh Thakur Category: Servlet with MySql Database

This Function will return the degree value from radian expression. I made a database first named 'dbase' within the reference of mySql(php myAdmin). Then i import all the required java packages from the java library. Here after i made a class named 'MySqlDEGREESFunction' which extends 'HttpServlet' Completely.



 
by Dinesh Thakur Category: Servlet with MySql Database

This function will use to wipe Duplicate columns and rows. The first i made a table named 'dept' with required fields and the values into a database named 'dbase' within the reference of mySql(php myAdmin). Then after i import all java packages from java library as program need. Here i made a class named 'MySqlDistnictJavaServlet' which extends 'HttpServlet'.i use service()Method that will help to getting the request from doGet()Method for output on web browser.



 
by Dinesh Thakur Category: Servlet with MySql Database

This function will return the Day of Year (1 to 365). First i made a database named 'dbase' within the reference of mySql(php myAdmin) with required fields and values in it. Then according to need of  program i import all the java packages from the java library. I create a class named 'MySqlDayOfYear' which extends 'HttpServlet'. Then i use serviceMethod() that will bring the request from doGet()Method for output on web browser.



 

Page 6 of 9



About Dinesh Thakur

Dinesh ThakurDinesh Thakur holds an B.C.A, MCSE, MCDBA, CCNA, CCNP, A+, SCJP certifications. Dinesh authors the hugely popular blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps. For any type of query or something that you think is missing, please feel free to Contact us.



Related Articles