ba_trainer
asked on
ORA 1843 not a valid month
I need to format the three dates in three different ways.
I am getting not valid month error.
Can you help? Thanks! Beth
I am getting not valid month error.
Can you help? Thanks! Beth
SELECT
PACKLIST.PACKLIST_NO,
to_date(TRANSACTION_DATE, 'dd-mm-yyyy'),
to_date(SCHEDULED_SHIP_DATE, 'mm-dd-yyyy'),
to_date(ACTUAL_SHIPPED_DATE, 'mm-dd-yy'),
JOBCOST_UNITS * COST_PER_UNIT AS EXTENDED_COST
FROM PACKLIST, JOBCOST
WHERE PACKLIST.PACKLIST_NO = JOBCOST.PACKLIST_NO;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
glad I could help
ASKER