Sql Query Help

[SUbba LIngam]

 

   Select To_timestamp_tz('Thu May 22 01:02:00 CDT 2014','Dy Mon DD HH24:MI:SS TZD YYYY') from dual 

 

   "5/22/2014 1:02:00.000000000 AM -05:00" - Result 

   

   select to_char('05/22/2014 1:02:00.000000000 AM -05:00', 'MM/DD/YYYY HH12:MI:SS') from dual 

   

   SYSDATE format ela try cheste ... Invalid Number ani error vastundi 

 

 

ala kadu vayya nenu andi,,,,,,,,, try this

 

select to_char(To_timestamp_tz('Thu May 22 21:02:00 CDT 2014','Dy Mon DD HH24:MI:SS TZD YYYY'), 'MM/DD/YYYY HH12:MI:SS AM') from dual;

[nenu_devudni]

nuvvu inka bathike unnava 

neku 10$ ki dubai flight book chesaka sachipota nenu ... 

[Johny]

select * from SQL ani kottu...kick untadhi...u illiterate fellow ani error vasthadhi.. 

[nenu_devudni]

ala kadu vayya nenu andi,,,,,,,,, try this

 

select to_char(To_timestamp_tz('Thu May 22 21:02:00 CDT 2014','Dy Mon DD HH24:MI:SS TZD YYYY'), 'MM/DD/YYYY HH12:MI:SS AM') from dual;

 

(.L@  thanks mayyya ... working now 

[bokuboy]

neku 10$ ki dubai flight book chesaka sachipota nenu ... 

 

life lo nuvvu chesina avamananni nenu marchiponu... $20 ke nannu nammale kadha, e db lo adigithe na kosam round triplu kadhu enni tickets ayina book chese vallu kadhu ani ninnu adigina chudu... hate u