Sql Query Help

[nenu_devudni]

E format ni SYSDATE ki convert cheyali bhayya ... kasta help cheyandi .. 

 

"Thu May 22 01:02:00 CDT 2014"

[ramu]

Try this....

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

[upendra_super]

ltt

[LungiLingaraju]

Final ga ela kavali chepu

[jaffanajeffada]

Try this....

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

:4_12_13:  :4_12_13: learnt something new today....

[nenu_devudni]

Try this....

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

Thanks mayya ... work ayindi .. 

[upendra_super]

Thanks mayya ... work ayindi .. 

https://community.oracle.com/thread/1062916?tstart=0

[nenu_devudni]

mayya tz_timestamp toh ee result vastundi ...  "5/22/2014 1:02:00.000000000 AM -05:00"

deni sysdate la convert cheyocha ??

[nenu_devudni]

i mean ee format lo 

 

9/11/2014 1:59:12 PM 

[SUbba LIngam]

mayya tz_timestamp toh ee result vastundi ... "5/22/2014 1:02:00.000000000 AM -05:00"
deni sysdate la convert cheyocha ??

select to_char(tz_timestamp, 'MM/DD/YYYY HH12:MI:SS AM') from dual

[nenu_devudni]

select to_char(tz_timestamp, 'MM/DD/YYYY HH12:MI:SS AM') from dual

 

naku edi oka date ee kadu ... it's a data load process bhayya so chala rows untay so avi anni convert cheyali sysdate format lo ... but data ela vastundi .. AM ani ala hardcode cheyalem kada ...

[SUbba LIngam]

naku edi oka date ee kadu ... it's a data load process bhayya so chala rows untay so avi anni convert cheyali sysdate format lo ... but data ela vastundi .. AM ani ala hardcode cheyalem kada ...

 

nuvvu first query run chesi chudu, adi AM ani mention chesina PM timings kuda vastundi le, dont worry.

[nenu_devudni]

   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 

 

[bokuboy]

E format ni SYSDATE ki convert cheyali bhayya ... kasta help cheyandi .. 

 

"Thu May 22 01:02:00 CDT 2014"

 

nuvvu inka bathike unnava 

[ramafdb]

aham brahmsymi

lytt