| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
