Jump to content

Need Help In Informatica


massmaharaj

Recommended Posts

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

Link to comment
Share on other sites

[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............. :3D_Smiles: :3D_Smiles: :3D_Smiles:

Link to comment
Share on other sites

[quote name='Dalapati' timestamp='1324099572' post='1301159151']

okasaari informatica antaav...........okasaari BO ataav............. :3D_Smiles: :3D_Smiles: :3D_Smiles:
[/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]

Link to comment
Share on other sites

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

Link to comment
Share on other sites

[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

Link to comment
Share on other sites

[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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

you rock you rock you rock you rock you rock

Link to comment
Share on other sites

  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...