Link to home
Start Free TrialLog in
Avatar of ba_trainer
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
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;

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ba_trainer
ba_trainer

ASKER

they are - perfect!! thanks so much! Beth
glad I could help