Mysql Date Snippets


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

PHP code to convert MySQL date to UNIX timestamp

Mysql Code example to find events made between two times not between two dates.

MySQL code example to calculate age from Date Of Birth

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

An example MYSQL function

15 December, 2012   

Allows you monitor how many times a link/image/banner is clicked.

13 June, 2013   

Allows you yo monitor how many times a link/image/banner is clicked, also allows you to diguise affiliate links. Consists of 1 small PHP file and is very easy to use.

19 December, 2012   

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

19 December, 2012   

Example shown here how to convert String to Date in Java

19 October, 2011   

An example to check Weekend

07 April, 2014   

Adding a linked server to MSSQL account - particularly a MYSQL server

23 January, 2013   

Returns the number of the quarter containing a given date.

29 December, 2012   

Example MySql code to append Data to Field in MySql

14 May, 2011   

This is a general code to use when updating 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.

09 May, 2011   

This is a general code to use when inserting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. An extention of this code would be to make sure the entry you are adding to the database doesn't already exist (to save dupicate entries). Note: This code requires you to connect to the MySQL...

15 February, 2012   

PHP code to displaying the current date in an HTML page.

14 February, 2012   

MySQL code to connect to db. Don't forget to change the parameters.

18 June, 2013   

Define few variables with your MySQL database connection settings and connect to MySQL database using mysql_connect() and mysql_select_db() functions.