Sql Query Help

[Vaampire]

select convert(varchar(50),datecolumn,112) from table1

[ganesh]

select substr('2009-03-05 11:59:30.000',1,4)||substr('2009-03-05 11:59:30.000',6,2) from dual

[ATRI]

select a.col1, b.col2
from table a
join table b on
to_char(substr(a.date,1,4)||substr(a.date,6,7)||substr(a.date,9,10))=b.datecol

[dotnetrockz]

[quote name='ATRI' timestamp='1335301704' post='1301682304']
select a.col1, b.col2
from table a
join table b on
to_char(substr(a.date,1,4)||substr(a.date,6,7)||substr(a.date,9,10))=b.date
[/quote]
idhi sql server lo na?

[Bairagi From Bapatla]

[quote name='ATRI' timestamp='1335301704' post='1301682304']
select a.col1, b.col2
from table a
join table b on
to_char(substr(a.date,1,4)||substr(a.date,6,7)||substr(a.date,9,10))=b.datecol
[/quote]
[quote name='Nissan' timestamp='1335302022' post='1301682329']
idhi sql server lo na?
[/quote]yeah naku kind of ilanti query kavali...
but sql server lo work ayyida....
select a.col1, a.col2, a.col3
from table a
join table b on
a.col1=b.col1,
a.col2=b.col2,
[color=#ff0000]here nenu cheppindi ravali like a.date(col3) = b.col3[/color]
[color=#ff0000]where ----------[/color]

[dotnetrockz]

[quote name='Bairagi From Bapatla' timestamp='1335306993' post='1301682585']
yeah naku kind of ilanti query kavali...
but sql server lo work ayyida....
select a.col1, a.col2, a.col3
from table a
join table b on
a.col1=b.col1,
a.col2=b.col2,
[color=#ff0000]here nenu cheppindi ravali like a.date(col3) = b.col3[/color]
[color=#ff0000]where ----------[/color]
[/quote]

oka table col datatype dateime inkokati varchar....join cheyyalevu direct ga.....

[Bairagi From Bapatla]

[quote name='Nissan' timestamp='1335311426' post='1301682846']
oka table col datatype dateime inkokati varchar....join cheyyalevu direct ga.....
[/quote]
PM chusuko baa....

[bujjulu]

[quote name='Bairagi From Bapatla' timestamp='1335296219' post='1301681722']
[left]2009-03-05 11:59:30.000 (yyyy-mm-dd time) ila ee format lo unna dhanni just naku 200903(yyyymm) ila ravalante query ela rayali.....[/left]


[left]Plz help[/left]
[/quote]

to_date(date, 'yyyymm')

[duryaodhana]

There is no to_date inbuilt function in SQL (till 2008). not sure added or not in one in SQL 2012

[NithinKrishna]

select

TO_CHAR(TO_DATE('2009-03-05','YYYY-MM-DD'),'YYYYMMDD') FROM DUAL

[Bairagi From Bapatla]

[color=#282828][font=helvetica, arial, sans-serif]scenario idhi baa....[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]table A table B unnai baaa....[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]nenu table a ni update cheyali based on table B column[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]table a n table b ni 3columns meedha join chesthunna....[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]aa 3columns lo okati date field...[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]table A lo[/font][/color]
[left][color=#282828][font=helvetica, arial, sans-serif]2009-03-05 11:59:30.000 format ila undi ; table B lo[/font][/color][/left]
[left][color=#282828][font=helvetica, arial, sans-serif]200903(yyyymm) format ila undi[/font][/color][/left]

[left][color=#282828][font=helvetica, arial, sans-serif]so table A lo unna format ni table B format ki marchi cheyali.... Lekapothe columns match avvav kada[/font][/color][/left]


[color=#282828][font=helvetica, arial, sans-serif]Query ela rayalo cheppandi baa....[/font][/color]

[dotnetrockz]

[quote name='Bairagi From Bapatla' timestamp='1335373148' post='1301685767']
[color=#282828][font=helvetica, arial, sans-serif]scenario idhi baa....[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]table A table B unnai baaa....[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]nenu table a ni update cheyali based on table B column[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]table a n table b ni 3columns meedha join chesthunna....[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]aa 3columns lo okati date field...[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]table A lo[/font][/color]

[left][color=#ff0000][font=helvetica, arial, sans-serif]2009-03-05 11:59:30.000 format ila undi ; table B lo[/font][/color][/left]
[left][color=#ff0000][font=helvetica, arial, sans-serif]200903(yyyymm) format ila undi[/font][/color][/left]

[left][color=#282828][font=helvetica, arial, sans-serif]so table A lo unna format ni table B format ki marchi cheyali.... Lekapothe columns match avvav kada[/font][/color][/left]


[color=#282828][font=helvetica, arial, sans-serif]Query ela rayalo cheppandi baa....[/font][/color]
[/quote]
ee paina columns rendu same datatypes aa?

[kiraaaak]

B.date column name = TO_CHAR(TO_DATE([b]TABLE A.columnname[/b]),'YYYYMM')

[dotnetrockz]

[quote name='kiraaaak' timestamp='1335373406' post='1301685789']
B.date column name = TO_CHAR(TO_DATE([b]TABLE A.columnname[/b]),'YYYYMM')
[/quote]
athanu ad
igedhi sql server lo mama....

andharu to_char,To_int ivvani pl/sql kadha....?

[kiraaaak]

[quote name='Nissan' timestamp='1335373624' post='1301685802']
athanu ad
igedhi sql server lo mama....

andharu to_char,To_int ivvani pl/sql kadha....?
[/quote]
Avnu ba pl/sql ee ... query annadu kada ani rasesaa