Home » Applications » Oracle Fusion Apps & E-Business Suite » conversion into date datatype
conversion into date datatype [message #168776] Sat, 22 April 2006 09:35 Go to next message
vk_appstech
Messages: 22
Registered: October 2005
Location: hyd
Junior Member
Hi All,
can some one give me the best way to convert a varchar into date.
lets say for example i have a column(varchar2) that contains 22apr2006.now i have to convert this string format into date format for the column that contains Date datatype.
hope i am clear.
Thanks in Advance
vk

Report message to a moderator

Re: conversion into date datatype [message #168781 is a reply to message #168776] Sat, 22 April 2006 11:41 Go to previous messageGo to next message
srinivnp
Messages: 136
Registered: January 2006
Location: stlouis MO USA
Senior Member
Use to_date with format ddmonyyyy.

select to_date('22apr2006','ddmonyyyy') from dual;




Srini

Report message to a moderator

Re: conversion into date datatype [message #168867 is a reply to message #168776] Sun, 23 April 2006 22:06 Go to previous messageGo to next message
manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC
Senior Member
select to_date('22APR2006') from dual;

Report message to a moderator

Re: conversion into date datatype [message #168872 is a reply to message #168776] Sun, 23 April 2006 23:15 Go to previous messageGo to next message
vk_appstech
Messages: 22
Registered: October 2005
Location: hyd
Junior Member
srini
i have 40 columns of data type VARCHAR2.so i dont want to use the to_date for every column.so i was actually trying for some generic functionality to convert all at once during conversion process(from legacy system).Hope you got my point now.

Report message to a moderator

Re: conversion into date datatype [message #168875 is a reply to message #168872] Sun, 23 April 2006 23:27 Go to previous messageGo to next message
manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC
Senior Member
If you are not willing to use to_date function then you may right own code, which depicts to_date function logic.

Report message to a moderator

Re: conversion into date datatype [message #169094 is a reply to message #168872] Tue, 25 April 2006 01:07 Go to previous message
srikanth_hans
Messages: 8
Registered: April 2006
Junior Member
apply the to_date function while loading the data into staging table ie in the control file while using the sqlldr.

hope this will help you.

Report message to a moderator

Previous Topic: HOW TO ENTRIES TRANSFER FROM PAYABLES TO GL
Next Topic: Oracle Apps Sys Admin -- Disabling a button on a form
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 11:24:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.