Character Field convert to date format

[upaliwije]

Dear Friends

My following date is stored as a character  field in oracle table. How can I convert into date format in Load script

Pls help me

07-MAR-13

[maxgro]

if you have a char use date# 

date#('07-MAR-13', 'DD-MMM-YYYY')

in script

load

     ...,

     date#(YOURCHARFIELD, 'DD-MMM-YYYY') as NewDate,

     ...

     ;

SQL

     select

     .....

     YOURCHARFIELD,

     ....

     from

     YOURORACLETABLE;

[jagan]

Hi,

Try like this

In Qlikview

LOAD

*,

Date(Date#(DateFieldName, 'DD-MMM-YYYY'), 'MM/DD/YYYY') AS FormattedDate

FROM DataSource;

In Oracle

SELECT

*,

To_char(DateFieldName, 'MM/DD/YYYY') AS FormattedDate

FROM TableName;

Hope this helps you.

Regards,

Jagan.