[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

ORA 1843 not a valid month

Posted on 2009-07-14
3
Medium Priority
?
1,199 Views
Last Modified: 2013-12-19
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

0
Comment
Question by:ba_trainer
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 24853164
if the three columns are dates, use to_char instead of to_date


SELECT
PACKLIST.PACKLIST_NO,
to_char(TRANSACTION_DATE, 'dd-mm-yyyy'),
to_char(SCHEDULED_SHIP_DATE, 'mm-dd-yyyy'),
to_char(ACTUAL_SHIPPED_DATE, 'mm-dd-yy'),
JOBCOST_UNITS * COST_PER_UNIT AS EXTENDED_COST
FROM PACKLIST, JOBCOST
WHERE PACKLIST.PACKLIST_NO = JOBCOST.PACKLIST_NO;
0
 

Author Closing Comment

by:ba_trainer
ID: 31603436
they are - perfect!! thanks so much! Beth
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 24853198
glad I could help
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question