Sql Doubt

[nikhilboorla]

how to find employees joined between jan 1 and jan 30 in 2014??

and how to convert string date into datetime ??

Please help

[coffee]

which db?

 

table lo date em format lo undi?

[loveindia]

how to find employees joined between jan 1 and jan 30 in 2014??

and how to convert string date into datetime ??

Please help

 

what is the query you tried first? then I can give you an example... I don't want to just answer assignment questions man... everyone please follow same... just don't give answers cos you know.. only answer to those who are trying man...

[Chitralekha]

SELECT *
FROM Table
WHERE Joined BETWEEN TO_DATE ('2003/01/01', 'yyyy/mm/dd')
AND TO_DATE ('2003/12/31', 'yyyy/mm/dd');

[nikhilboorla]

these are not assignment questions...these are interview questions asked by some famous company

what is the query you tried first? then I can give you an example... I don't want to just answer assignment questions man... everyone please follow same... just don't give answers cos you know.. only answer to those who are trying man...

 

[KilllBilll]

monday mrng varaku aagu 

[loveindia]

these are not assignment questions...these are interview questions asked by some famous company

 

questions chustey basic unnayi.... company emo famous antunnav.... endo man...

 

any how..

 

employees from Jan 1st to Jan30

 

select count(*) as count from employees where empstartdate between '01/01/2014' and '30/01/2014'

 

date to string

 

you can use CAST, CONVERT and use which datepart you want as required... google CONVERT in SQL to know what is a datepart.

[coffee]

questions chustey basic unnayi.... company emo famous antunnav.... endo man...

 

any how..

 

employees from Jan 1st to Jan30

 

select count(*) as count from employees where empstartdate between '01/01/2014' and '30/01/2014'

 

date to string

 

you can use CAST, CONVERT and use which datepart you want as required... google CONVERT in SQL to know what is a datepart.

neeku netezza vacha?

[Chitralekha]

teradata lo ithe diffrnt ga rayalemo

[loveindia]

neeku netezza vacha?

 

little bit man...

[loveindia]

teradata lo ithe diffrnt ga rayalemo

 

akkada sql ani adigitey nuvvu teradata , mainframes ani alochistunnav enti man...

[Chitralekha]

lol teradata lo sql vere gaa rastham kadha antunna

[loveindia]

lol teradata lo sql vere gaa rastham kadha antunna

 

sql ekkadaina sql ye man... platforms will be different antey so keywords will differ...huge changes will come in when you are using logics in teradata... not with sql man...

[spidereddy]

Thumbs down

[Darling999]

TEradta ayinam SQL ayina painaa love india eaasina query chooskoo