Sql Date Function Snippets


31 October, 2011   

It is a class file which can export to excel. simply call the function and give sql Query and sql connection.

30 December, 2010   

Class to back up entire databases and email them out, or individual tables

Change Graphics Based on Season

26 December, 2011   

Example PHP code to navigate calender in HTML pages

18 February, 2011   

Change Graphics Based on Season

In order for this to work, you will need to copy mysqldump.exe and mysql.exe from the MySQL bin Program Files folder into the same directory as your executing PHP script. If you know the direct path to these for your server, you can use those instead.

15 February, 2012   

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

09 February, 2011   

Class to back up entire databases and email them out, or individual tables.

PHP code to convert MySQL date to UNIX timestamp

16 November, 2013   

This function lets you check whether an date event should recur on a specified date. This is handy for calendar, billing and reminder applications.

This function builds an HTML select list from from data retrieved from a mySQL table.

09 October, 2011   

Example shows how to get the database date and time.

By default, Delphi gets its date/time, currency and numeric format from Control Panel's International settings. We can set the constants defined in Delphi, like DecimalSeparator, ShortDateFormat and others like in the code below. To a complete list of these variables, look at Currency and date/time formatting variables in Delphi Help.

08 September, 2012   

SQL query to know total number of employee on each department.

31 December, 2011   

How to create a procedure for date calculation

05 May, 2012   

ASP code example to return a long representing the record count returned by an SQL statement

08 September, 2012   

SQL query to know employees where city is null

01 October, 2013   

This class has lots of common functionality built right into it. It also supports Mysql and Sphinx.

13 May, 2013   

You can also run this an anonymous SQL Block

An example MYSQL function