Home » RDBMS Server » Server Administration » Re: To_Date Function
Re: To_Date Function [message #370254] Wed, 14 July 1999 08:49
Chris Hunt
Messages: 27
Registered: March 1999
Junior Member
If <VAR>new_date_from</VAR> and <VAR>new_start_time</VAR> are both DATE fields, your statement ought to work - I've just proved this by substituting <VAR>sysdate</VAR> for both of them.

To track down your problem, try removing the outer TO_DATE, followed by selecting each TO_CHAR function seperately. This should show you which conversion function is failing and give a clue as to the solution.

Previous Topic: Re: Sequence vs Rowid in primary key
Next Topic: Re: Help on Date type with OO4O
Goto Forum:

Current Time: Wed Oct 28 07:22:08 CDT 2020