Select Date Snippets


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

09 October, 2011   

Example shows how to get the database date and time.

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

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

MySQL code example to calculate age from Date Of Birth

23 September, 2011   

An example Dates with the Ordinal Suffix . Below is the code that will do this.

This example has an ordinal suffix: Sunday 15th July

26 February, 2011   

Here shown how to highlight syntax

An example MYSQL function

31 December, 2011   

How to create a procedure for date calculation

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

20 June, 2013   

How to select between two dates using MySQL code

13 November, 2011   

How to find records with last date of month

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

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.

19 October, 2011   

An example to check Weekend