I'm trying to write a query that gives the persons age but the only two fields I have to work with are the BirthDate and the GetDate() fields.
I tried "select year(GetDate()) - year(BirthDate)...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20149849.html
I'm looking for a fairly simple script to validate the birthdate on a form. I just want to ensure that the applicants are not under 13 years. (nothing more)
Thanks!
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20397508.htm...
Zones:
ASPDate Answered: 11/14/2002 Grade: B Views: 0
Hi,
I have a method that receives input as a String which *should* be in the form of mm/dd/yy. Now what I have to do is take the month in as a number and return a textual month. Ex. 01/23/67 w...
http://www.experts-exchange.com/Programming/Languages/Java/Q_20875227.html
Zones:
JavaDate Answered: 02/05/2004 Grade: A Views: 0
Hi
I have an ID Number field.......e.g. 7511230024083.....the first two digits is the year (1975), next two is the month (11 - october) and then next two the date (23rd). this is placed in a te...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_21301588.html
I have a javascript function that checks to see if the person is over 18 according to the date of birth they entered in a text box. My problem is that today's date is 3/28/2006 and if they enter a...
http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_21792148.html
Zones:
JavaScriptDate Answered: 03/29/2006 Grade: A Views: 52
Ive got a query created with a birthdate field in the following format mm/dd/yyyy. I want to know how I can sort just this field chronologically by the month--say Jan, Feb, Mar, and so forth.
http://www.experts-exchange.com/Database/Miscellaneous/Q_20553532.html
Zones:
DatabasesDate Answered: 02/16/2004 Grade: A Views: 0
Hey everyone, im having a dabble at inheritance. Ive got my two classes and now i need to test my derived class, but nothing is working even when i use the default constructor for it.
Can someon...
http://www.experts-exchange.com/Programming/Languages/CPP/Q_21399038.html
Zones:
C++Date Answered: 04/22/2005 Grade: B Views: 0
I am wondering if somebody can write a Oracle SQL statement for the following case:
I have 2 tables: PERSONS (where I keep my address and private details of employees and their relatives) and DE...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10220873.html
I have a birthday field formatted as mm\dd\yyyy and I need to format it as ccyymmdd. For example the existing date is 11/24/1929 and I need to change it to 19291124.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20776827.html
Zones:
MS AccessDate Answered: 10/24/2003 Grade: A Views: 13
Hi,
my table has a field called birthdate, with type date. the data are stored in the form of yyyy-mm-dd
how do i select from my database, list of birthdates, sorted from the most upcoming on...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_21341521.htm...
Zones:
PHPDate Answered: 03/07/2005 Grade: A Views: 0
