massmaharaj Posted December 17, 2011 Report Posted December 17, 2011 HI friends source is oracle target is file from source ( view ) in view there is a query which pulls the data The issue is The date which comes from source is like this 07/20/2011 15:54:15 But the expected would be 07/20/2011 3:54:15 PM how to convert from 24 hour to 12 hour format in expression can you please help me Pavan Quote
Bhayya Posted December 17, 2011 Report Posted December 17, 2011 basic sql la ayite date format change cheste ayipotadi... hh24 ni hh12 cheyyali... Ee case la adi pani cheyyada? Quote
dilkush Posted December 17, 2011 Report Posted December 17, 2011 [quote name='subba rav' timestamp='1324098921' post='1301159126'] basic sql la ayite date format change cheste ayipotadi... hh24 ni hh12 cheyyali... Ee case la adi pani cheyyada? [/quote] okasaari informatica antaav...........okasaari BO ataav............. Quote
Bhayya Posted December 17, 2011 Report Posted December 17, 2011 [quote name='Dalapati' timestamp='1324099572' post='1301159151'] okasaari informatica antaav...........okasaari BO ataav............. [/quote] cycle tokkadam oste luna nadapocchu, sports bike nadapocchu... sql oste data stage cheyyocchu, BO cheyyocchu, informatica cheyyocchu [img]http://lh4.ggpht.com/-G8Sz6OR3Vsg/TjTi5W_KV-I/AAAAAAAADhs/kT8gb5bD_AI/brahmi.gif[/img] Quote
dilkush Posted December 17, 2011 Report Posted December 17, 2011 [quote name='subba rav' timestamp='1324099733' post='1301159159'] cycle tokkadam oste luna nadapocchu, sports bike nadapocchu... sql oste data stage cheyyocchu, BO cheyyocchu, informatica cheyyocchu [img]http://lh4.ggpht.com/-G8Sz6OR3Vsg/TjTi5W_KV-I/AAAAAAAADhs/kT8gb5bD_AI/brahmi.gif[/img] [/quote] [img]http://www.desigifs.com/sites/default/files/t0rxi0.gif?1290018352[/img]........inthakie ippudu nuvvu chesthunnadhi dheni meedha...... Quote
Trader joe Posted December 17, 2011 Report Posted December 17, 2011 TO_DATE(TO_CHAR(COLUMN_NAME, 'MM/DD/YYYY HHMMSS'),'MM/DD/YYYY HHMMSS') Quote
afdb_sai Posted December 17, 2011 Report Posted December 17, 2011 [quote name='massmaharaj' timestamp='1324098331' post='1301159099'] HI friends source is oracle target is file from source ( view ) in view there is a query which pulls the data The issue is The date which comes from source is like this 07/20/2011 15:54:15 But the expected would be 07/20/2011 3:54:15 PM how to convert from 24 hour to 12 hour format in expression can you please help me Pavan [/quote] in expression to_date function change the date format to hh24 to hh Quote
150bryant Posted December 17, 2011 Report Posted December 17, 2011 [quote name='afdb_sai' timestamp='1324100330' post='1301159187'] in expression to_date function change the date format to hh24 to hh [/quote] bhaiyaoo...do not upgrade now. do it on sunday ni8 pls Quote
Bhayya Posted December 17, 2011 Report Posted December 17, 2011 [quote name='Dalapati' timestamp='1324099940' post='1301159169'] [img]http://www.desigifs.com/sites/default/files/t0rxi0.gif?1290018352[/img]........inthakie ippudu nuvvu chesthunnadhi dheni meedha...... [/quote] oka data warehouse proj ki data/business analyst + tech team lead ni... [img]http://lh6.ggpht.com/-HzcrFPcvPp8/TnyuZkIjohI/AAAAAAAAEWE/n6sTQQAY_Us/Brahmi-8.gif[/img] Quote
dilkush Posted December 17, 2011 Report Posted December 17, 2011 [quote name='subba rav' timestamp='1324100645' post='1301159201'] oka data warehouse proj ki data/business analyst + tech team lead ni... [img]http://lh6.ggpht.com/-HzcrFPcvPp8/TnyuZkIjohI/AAAAAAAAEWE/n6sTQQAY_Us/Brahmi-8.gif[/img] [/quote] Quote
massmaharaj Posted December 20, 2011 Author Report Posted December 20, 2011 Thanks Everyone for your posts and suggestions I fixed the issue by using your suggestions Thanks Pavan Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.