TO_DATE SQl question   Independent houses near kukatpally | Apartments in Pragathi Nagar | AndhraVaani.com | Log Out | Topics | Search
Register | Edit Profile

Bewarse TalkArchives - 2008Cine Talk - Reviews, Gossips, Insider Info etc.Archive through March 24, 2008 � TO_DATE SQl question Previous Next

Author Message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 51541
Registered: 07-2004
Posted From: 70.44.12.14

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 7:05 pm:Edit PostDelete PostView Post/Check IP

nayak baa,manam undedhi USLo,paisal india ampatledhu....idhi kooda anthe
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6228
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 6:19 pm:Edit PostDelete PostView Post/Check IP

nayakudu mama
Top of pagePrevious messageNext messageBottom of pageLink to this message

Drifter
Yavvanam Kaatesina Bewarse
Username: Drifter

Post Number: 3942
Registered: 09-2007
Posted From: 138.32.32.166

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 6:19 pm:Edit PostDelete PostView Post/Check IP

GOSI neevu vundedi US lo INDIA lo tax KADUTHAva ikkada kattakunda
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6227
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 6:18 pm:Edit PostDelete PostView Post/Check IP

gochesh enta navvu.

ammani..maa oore..rachamass aaa endi. antha posh english ledemo.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Drifter
Yavvanam Kaatesina Bewarse
Username: Drifter

Post Number: 3941
Registered: 09-2007
Posted From: 138.32.32.166

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 6:17 pm:Edit PostDelete PostView Post/Check IP

GOSI mee hero gurinchi questionr aise chesaru.. surrogate vi answer cheyyi... vundedi AP lo tax lu TN lona kattedi
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 51540
Registered: 07-2004
Posted From: 70.44.12.14

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 6:12 pm:Edit PostDelete PostView Post/Check IP

Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6226
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 6:10 pm:Edit PostDelete PostView Post/Check IP

evaru rose
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6225
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 6:10 pm:Edit PostDelete PostView Post/Check IP

hmm...ento ardam kavatam ledu query marchina anthaku mundu unna data ne vachindi.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Rose
Pilla Bewarse
Username: Rose

Post Number: 300
Registered: 03-2005
Posted From: 24.148.220.231

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 6:09 pm:Edit PostDelete PostView Post/Check IP

Top of pagePrevious messageNext messageBottom of pageLink to this message

Rose
Pilla Bewarse
Username: Rose

Post Number: 299
Registered: 03-2005
Posted From: 24.148.220.231

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 6:08 pm:Edit PostDelete PostView Post/Check IP

Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6224
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 6:08 pm:Edit PostDelete PostView Post/Check IP

rose, thank you
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6223
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 6:07 pm:Edit PostDelete PostView Post/Check IP

creation_date type date ee.. so inka to_date ivvalsina avasaram ledu. where lo right hand side '01-jan-2007' ani icha. daniki to_date petti gochesh ichindi ichanu. work ayinatte undi :-)

thanks mamalu :-)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Rose
Pilla Bewarse
Username: Rose

Post Number: 297
Registered: 03-2005
Posted From: 24.148.220.231

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 6:01 pm:Edit PostDelete PostView Post/Check IP

creation date column data type meeda depend avutundi. nuvvu century expand cheyyankunda YY format lo data iste, adi current century ki CAST chestundi. ante 20YY. so first di correct.

Second daantlo creation date column lo century value ledu. so ikkada 00 vastunnadi. check ur source value in creation_Date first.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 51539
Registered: 07-2004
Posted From: 70.44.12.14

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 6:00 pm:Edit PostDelete PostView Post/Check IP

same touch,beeresh
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3583
Registered: 09-2006
Posted From: 24.183.183.235

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 5:59 pm:Edit PostDelete PostView Post/Check IP

gosayys
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3582
Registered: 09-2006
Posted From: 24.183.183.235

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 5:58 pm:Edit PostDelete PostView Post/Check IP

created_date date datatype aite use to_char

select to_char(creation_date, 'DD/MM/YYYY') FROM TABLENAME
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 51538
Registered: 07-2004
Posted From: 70.44.12.14

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 5:58 pm:Edit PostDelete PostView Post/Check IP

to_char(creation_date, 'DD/MM/YY') try seyyi hemesh
Top of pagePrevious messageNext messageBottom of pageLink to this message

Beer
Yavvanam Kaatesina Bewarse
Username: Beer

Post Number: 3581
Registered: 09-2006
Posted From: 24.183.183.235

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 5:53 pm:Edit PostDelete PostView Post/Check IP

intaki created_date datatype enti date?, varchar2?
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 6222
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Wednesday, March 19, 2008 - 5:41 pm:Edit PostDelete PostView Post/Check IP

nenu TO_DATE(creation_date, 'DD/MM/YY') FROM TABLENAME

ani isthunte value 2/18/2098 ani vasthundi. kani akkada unna creation_date 1998. idendi?

sare ani TO_DATE(creation_date, 'DD/MM/YYYY') ani isthe 2/18/0098 ani vasthundi value. ela correct value thesuku ravali