we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz
Answers were Sorted based on User's Feedback
Answer / rajesh k. gupta
Hi,
In order to answer your question I would like to put all
three possible answers as follows:-
1.If You want to find out the age of employee as on the
date of Joining (Field name EDOJ) then Query will be
select *,datediff(year,EDOB,EDOJ) as Eage from emp
2. If you want to find out the age of employees as on
current date, query will be as follows:-
select *,datediff(year,EDOB,getdate()) from emp
3. If you want to find out age as on specific date stored
and taken from other variable then query will be :-
You need to declare a variable as datetime then need to
tore its value to it.
declare @dtb datetime
set @dtb='1990/01/10'
select *,datediff(year,EDOB,@dtb) from emp
---------------------------------------
For any clarification Please feel free to contact me.
Rajesh
9342284359
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / monal
FOR SQL 2005:
select datediff (day, birthdate, getdate())/365 from emp
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / santhi k
Answer i submitted is for Oracle not for SQL server.
Sorry!
Plz always mention the RDBMS which you are using ,in the
post.
Bcoz,This Oracle query may not work in other RDBMS.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / rajesh k. gupta
The answer submitted by Santhi K is wrong, Can shanti test
this query in sql server, because i ran it it does not
accept. there is no such months_between function
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / santhi k
select trunc(months_between(Sysdate,EDOB)/12)Age from emp;
| Is This Answer Correct ? | 0 Yes | 2 No |
Differentiate between SQL and ORACLE joins and write their syntax.
What is data source in connection string?
What is a recursive stored procedure in sql server?
What are different type of Collation Sensitivity?
What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.
Why can there be only one clustered index and not more than one?
* CREATE TABLE [dbo].[t_Colors]([ColorId] [int] NOT NULL,[ColorName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ColorDesc] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[ColorIndex] [int] NULL) ON [PRIMARY] GO * insert into [t_Colors] values(101,'Red','',1) insert into [t_Colors] values(101,'Red1','',2) insert into [t_Colors] values(102,'Blue','',1) insert into [t_Colors] values(102,'Blue1','',2) insert into [t_Colors] values(102,'Blue2','',3) * In this table i need to delete DELETE FROM t_Colors WHERE ColorIndex=1 AND ColorId=102 After delete above condition i need to update the ColorIndex set to 1 for Blue1[ColorName] and 2 for Blue2[ColorName] select * from [t_Colors] Note:- how can i get updates the ColorIndex values after delete. for example we need to update Blue1 ColorIndex set to 1 and Blue2 ColorIndex set to 2
statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance
Can I delete event logs?
What is table join?
How to create a Master database in SQL server ?
Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)