Sql Date Function Snippets

19 December, 2012   

How to convert a java util Date into a sql Date for use in databases.

Handy helper function which parses about any date and returns the same date in MySQL date/time format.

Change Date from dd/mm/yyyy to yyyy-dd-mm

20 February, 2012   

SQL select query to show records with specify date in where clause

26 February, 2011   

Here shown how to highlight syntax

20 February, 2012   

SQL select query with between date to show records in where clause

03 November, 2011   

Here are some simple examples of using the functions with your variables. Run these from any ".asp" page and watch what happens

18 June, 2012   

An example of Stored PL/SQL blocks

PL/SQL functions returns a scalar value and PL/SQL procedures return nothing. Both can take zero or more number of parameters as input or output. The special feature about PL/SQL is that a procedure/function argument can be of input (indicating the argument is read-only), output (indicating the argument is write-only) or both (both readable and...

21 January, 2012   

PL/SQL Block that uses implicit cursor attributes as below example code.

23 January, 2013   

Returns the number of the quarter containing a given date.

11 July, 2013   

Help manage mysql database common task

19 December, 2012   

Example shown here how to convert String to Date in Java

01 December, 2011   

The following code block shows how to run DML statements in PL/SQL. Basically they look similar to the SQL. Note that the SELECT statement retrieves the single-row value and store into a variable using INTO clause.

JavaScript code to get time intervals between two Dates

09 May, 2011   

This is a general code to use when selecting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match. This MYSQL Code using in PHP

19 October, 2011   

An example to check Weekend

Exam code to backup MySQL Database to SQL File

PHP code example to get All-Time Number of MySQL Queries

18 January, 2012   

SQL GROUP BY Clause returns group of rows. An example code for SQL GROUP BY clause