Age Calculator in SQL Server

Hi, Friends!

Today is a Special Day in my Life, "My Birthday".

Yeah!!! This is "20th August".

So, Today I calculate my age using Age Calculator in SQL Server.

USE tempdb

DECLARE @BIRTHDATE AS DATETIME = '1987-08-20 07:50:00.000'

DECLARE @TODATE AS DATETIME = '2015-08-20 00:00:00.000' --[You may use GETDATE()also]

SELECT DATEPART (YEAR,        @TODATE-@BIRTHDATE)-1900 AS [Years], 

       DATEPART (MONTH,       @TODATE-@BIRTHDATE)-1 AS [Months],  

       DATEPART (DAY,         @TODATE-@BIRTHDATE)-1 AS [Days],

       DATEPART (HOUR,        @TODATE-@BIRTHDATE) AS [Hours],

       DATEPART (MINUTE,      @TODATE-@BIRTHDATE) AS [Minutes],

       DATEPART (SECOND,      @TODATE-@BIRTHDATE) AS [Seconds],

       DATEPART (MILLISECOND, @TODATE-@BIRTHDATE) AS [Milliseconds]

Result:-

Years Months Days  Hours Minutes Seconds Milliseconds

28      0     0     16    10      0        0

WOW!!! Im just turn into 28 years Guy!!!...

Name Numerology Destiny number

Pythagorean Numerology Number Chart

1 2 3 4 5 6 7 8 9

A B C D E F G H I

J K L M N O P Q R

S T U V W X Y Z

ARKA = 1+9+2+1 = 13

GUPTA = 7+3+7+2+1 = 20

13+20 = 33 = 3+3 = 6

Chaldean Numerology Number Chart

1 2 3 4 5 6 7 8

A B C D E U O F

I K G M H V Z P

J R L T N W

Q S X

Y

ARKA = 1+2+2+1 = 6

GUPTA = 3+6+8+4+1 = 22

6+22 = 28 = 10 = 1+0 = 1

Result:

Number	Positive qualities	Negative qualities
1	Initiative, leadership, individuality, courage, executive ability.	Selfishness, laziness, aggressiveness, egotism.
2	Co-operation, harmony, love, partnership, diplomacy.	Over sensitive, tactlessness, timidity, vacillation.
3	Artistic and Creativity, self-expression, imagination, sociability, cheerfulness.	Pessimism, loose talks, exaggeration.
4	Constructive, systematic, practicality, order, builder, industrious.	Lack of imagination, argumentative, extreme seriousness, ill-health.
5	Constructive freedom, sexuality, versatility, knowledge, entertainment and amusement.	Changeability, carelessness, restlessness, nervousness, jack of all trades.
6	Artist, responsibility, love of home and children, welfare of others, unselfish.	Sensitiveness, coldness, nervousness, skepticism, must learn to be alone, not lonely.
7	Spirituality, occult, analysis, scientific research, wisdom.	Selfishness, laziness, aggressiveness, egotism.
8	Executive ability, organization, authority, judgment, administration.	Impatience, love of recognition, lack of humanitarianism, too much materialism.
9	Philanthropic nature, humanitarianism, sympathy, selflessness, divine life, generous.	Moody and impulsive, must learn selfishness, carelessness in money matters, inclination for high living.
11	Intuition, illumination, inspiration, spirituality, prophetic ability.	Too much sensitiveness, nervous tension, impracticality, must learn to mingle with public.
22	Materialism, spiritual master, practical, luminary.	Conflict between inner feelings and practicality, attraction for black magic.

Read XML File in SQL Server

Example of XML Node Attribute :

Example of XML Node :

Example of XML Node using SQL query :

DECLARE @X xml

SELECT @X ='<Members>

            <Member Id="010619" Name="Arka Gupta" Email="arkaa4@gmail.com">

            </Member>

            <Member Id="010276" Name="Ram Chandra" Email="rc@gmail.com">   

            </Member>

            <Member Id="010630" Name="Laxman Kumar" Email="lk@gmail.com">

            </Member>

            <Member Id="010273" Name="Sundar Raman" Email="sr@gmail.com">

            </Member>

           </Members>'

SELECT      Members.Member.value('@Id','VARCHAR(20)')  AS 'ID',

            Members.Member.value('@Name','VARCHAR(100)') AS 'Name',

            Members.Member.value('@Email','VARCHAR(100)') AS 'Email'

FROM @X.nodes('/Members/Member') AS Members(Member)

If  there is any other better option,

Please share it here or mail to me arkaa4@gmail.com

Thank You,
Arka Gupta.

http://arkaguptablog.blogspot.in/

https://plus.google.com/+ArkaGupta-arkagupta/posts

https://in.linkedin.com/in/arkagupta