Convert 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

19 December, 2012   

Example shown here how to convert String to Date in Java

19 December, 2012   

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

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

MySQL code example to calculate age from Date Of Birth

10 October, 2012   

Converts a date or time from one timezone to another.

05 July, 2012   

Converts a date or time from one timezone to another.

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

I was trying to pass an array through SWFObject flashvars and realized it can't be done. Instead you need to use a string for your array, pass it into Flash , then convert it to an array using the actionscript "split" function.

I was trying to pass an array through SWFObject flashvars and realized it can't be done. Instead you need to use a string for your array, pass it into Flash , then convert it to an array using the actionscript "split" 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.

This example asp code shows here how to convert from degrees to radians and vice versa

22 September, 2012   

Javascript code to convert a string to all upper or lowercase

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.