Need Help In Informatica

[massmaharaj]

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

[Bhayya]

basic sql la ayite date format change cheste ayipotadi... hh24 ni hh12 cheyyali...

Ee case la adi pani cheyyada?

[dilkush]

[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.............

[Bhayya]

[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]

[dilkush]

[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......

[Trader joe]

TO_DATE(TO_CHAR(COLUMN_NAME, 'MM/DD/YYYY HHMMSS'),'MM/DD/YYYY HHMMSS')

[afdb_sai]

[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

[150bryant]

[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

[Bhayya]

[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]

[dilkush]

[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]

[massmaharaj]

Thanks Everyone for your posts and suggestions

I fixed the issue by using your suggestions

Thanks
Pavan

[chowdary9]