dob2age.sql

Category: Other - Tools & Utilities

This script shows you how to convert a Date of Birth into the current Age.Suppose you have a table People - containing information about .. people, that has a field DoB, which is of the type DATE and that contains the Date of Birth. It is fairly simple to calculate the current age as shown in this script. Of course, NOW() can be substituted for any DATE(TIME) field, or a string of the format YYYY-mm-dd. Date: 03 January, 2012


Date Converter - Sql Script - Database Tool - Date - Converter - Sql

Homepage: http://devshed.excudo.net/

Developer: devshed.excudo.net

License: Freeware

Operating System: All

Add a Comment

all are required fields

     
What do you think of this resource?

Select Your Rate:

Votes:0

 

Related Scripts Download

decimal_ip_converter.

developer Developer: devshed.excudo.net
license License: Freeware
operating systems Operating System: All


Editor for SQL files like built-in editors (for now highlighting only).

developer Developer: plugins.intellij.net
license License: Freeware
operating systems Operating System: Windows


SQLCE Scripter is a GUI application which takes SQL CE database filename and generates database schema and data scripts.

developer Developer: sqlmgmt
license License: Freeware
operating systems Operating System: Not Available


neo_my2pg is a Python script for migration from mysql to postgresql.

developer Developer: SourceForge.net
license License: Artistic License, GNU General Public License (GPL)
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris


sqlWebArchitect is a Web-Based Open Source SQL Server and MSDE Database Administration tool.

developer Developer: SourceForge.net
license License: Artistic License, GNU General Public License (GPL)
operating systems Operating System: Windows


SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

developer Developer: SourceForge.net
license License: Artistic License, GNU General Public License (GPL)
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris


Download Trakker masks the true address of a URL.

developer Developer: scriptsforyou.net
license License: Freeware
operating systems Operating System: All


decimal_ip_converter.

developer Developer: devshed.excudo.net
license License: Freeware
operating systems Operating System: All


phpMinAdmin is a MySQL management tool written in PHP.

developer Developer: SourceForge.net
license License: Freeware
operating systems Operating System: All