How to calculate Age using SQL Query
DateDiff function can be used to get the Age from the birth date
Select BirthDate, DateDiff(year, BirthDate, getdate()) as Age from HumanResources.Employee
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Now () Function in SQL Server 2005 Logs, Status Reports and et al., Now() function is common. Here is the way to accomplish the same in SQL ...
-
Get the HOST NAME / COMPUTER NAME Get the Computer Name using SQL Query Select Host_Name() as Computer_Name Get Computer Name, Get HOst Name...
-
How to Create Primary Key in SQL Server Management Studio In Table Designer, click the row selector for the database column you want to defi... -
While loop in T-SQL Here is a simple example of While loop Declare @temp tinyint = 1 while ( @temp 11 ) begin print cast ( @temp...
-
How to check if a text exists within another in SQL Server 2008 / How to split SQL Column based on Comma You can use the combination of Ch...
-
All About Connections @@MAX_Connections Returns the maximum number of simultaneous user connections allowed on an instance of SQL Server. Th...
-
TimeStamp Column in SQL Server TimeStamp is used to store unique binary numbers within a database. This column is autogenerated with a sto... -
This error occurs when a variable name is preceded by # instead of @. # is used to declare temporary table declare #myi int Should be repl...
-
********************Youngest & Oldest Employee******************** To get the youngest / olderst employee, two different methods are sho...
-
ADO Connection String for Access 2007 Database Here is the ADO connection string example for Access 2007 database. Set Cn = New ADODB.Co...
4 comments:
That only works for users that have had their birthday already this year. If the users birthday is after the current date, the age is off by 1 year.
Datediff function worked perfectly for me.
Does not work.......
it will work...it will show in negative valueas a age in months...
Select BirthDate, DateDiff(month, BirthDate, getdate()) as Ageinmonths from HumanResources.Employee
http://www.w3schools.com/sql/func_datediff.asp
Post a Comment