EPIC next generation ERP-system

Epicor Software Corporation (NASDAQ: EPIC), a leading provider of enterprise business software solutions for the midmarket and divisions of Global 1000 companies, today announced that Epicor 9, the Company's next-generation enterprise resource planning (ERP) solution continues to gain momentum with more than 30,000 user seats shipped worldwide to date.

Both new and existing customers globally and across industries are realizing the benefits of Epicor's award-winning real-time business management solution, launched last year at the Company's annual global user conference.

"We are extremely pleased with the success Epicor 9 has achieved since its launch, both in terms of new customer wins, and existing customer implementations and migrations," said George Klaus, chairman, president and CEO for Epicor. "We are committed to delivering world class solutions, services and support to our customers -- to see them attain the benefits of improved business processes, productivity gains and overall success with Epicor 9 is gratifying. We expect the adoption of Epicor 9 to continue trending up, as we move toward availability of Epicor 9 in more than 50 countries and 30 languages by the end of next year."
EPIC next generation ERP-system

Oracle developer/consultant(Kiev, $2000-$3000)

Leading Canadian-based business and software consultancy specializing in Data Warehousing, Business Intelligence, Data Mining and Data Quality is looking for the specialists in Oracle development:
·                     At least 2 years in PL/SQL and Oracle DB
·                     Good command of UNIX and/or Windows environment
·                     Customer orientation and drive
·                     Experience with Data Warehousing, Business Intelligence and ETL is an advantage
·                     Experience from banking, financial services, insurance or telecommunications industries is preferable
·                     Fluent English, ability to work in English speaking environments
·                     Java working knowledge is an advantage
·                     Good analytical, communication and presentation skills
·                     Willingness to travel, flexibility to work both in Ukraine and abroad
Company offers:
·                     Excellent career opportunity with a leading software consultancy (Canadian company with operations in UK, Germany, Central and Eastern Europe)
·                     Extensive international training and strong career prospects
·                     Access to the latest technology and know-how
·                     Professional development plans for each person
·                     Young, dynamic and professional team
·                     Potential to work on international projects
If you are interested please send your cv to or call:5036614; icq:277198997

UPDATE a date column: literal does not match format string

When I try to update a date column with this:

        REQ_EVENT_DATE = TO_CHAR(REQ_EVENT_DATE - INTERVAL '1' HOUR, 'yyyy-mm-dd hh24:mi')

Oracle returns this error:

    ERROR at line 4:
    ORA-01861: literal does not match format string

where line 4 is REQ_EVENT_DATE = TO_CHAR(REQ_EVENT_DATE - INTERVAL '1' HOUR, 'yyyy-mm-dd hh24:mi').

The REQ_EVENT_DATE field was originally populated with this stripped down query:

$date = '2007-12-25 08:35';
INSERT INTO (REQ_EVENT_DATE) VALUES (to_date('$date', 'yyyy-mm-dd hh24:mi'));

So - what is wrong with the UPDATE query?