Sql Date Function Snippets


MySQL code example to calculate age from Date Of Birth

PHP code for current Month/Day/Date with HTML colors & formatting.

The mysql_fetch_assoc "converts" a row from a table into an associative array. The mysql_insert_array "converts" an associative array into a row in a table.

21 January, 2012   

PL/SQL code example for Explicit Cursors

03 April, 2018   

Returns the last day of the month containing the given date.

30 August, 2015   

Loads the contents of a dir an sorts them by the date of creation.

18 June, 2011   

You can create a function for logging system

SQL uses the MAX function to find the maximum value in a column.

Below shown how to Back Up and Restore a MySQL Database

05 July, 2012   

Backup MySQL Database to SQL File with mysqldump

29 December, 2012   

How to Back Up and Restore a MySQL Database

14 May, 2012   

How to generate SYNONYMS SQL

19 October, 2011   

An example to display Dynamic Date

18 January, 2012   

You can combine with SQL JOIN clause to show department name with count.

22 November, 2011   

JavaScript Code to display Dynamic Date

09 February, 2012   

Syntax for the Length function

13 November, 2011   

How to find records with last date of month

23 August, 2014   

Correctly calculate the date of Easter Sunday.

28 June, 2014   

Starting in Oracle 9i, you can use the case statement within an SQL statement. It has the functionality of an IF-THEN-ELSE statement.

05 May, 2012   

ASP code example with Sql Statement