sql problem with cast

[hilbrink]

Does anybody have a clue what is wrong with the following SQL statement?
SELECT cast('02-17-2001' AS date) ...rest of statement...

The error message i get is "Key violation. [oracle][odbc][ora]ORA-00905: missing keyword".

Thanx!

 

[stevecal]

Try this for size.

SELECT to_date('02-17-2001','dd-mm-yyyy')
...rest of statement.

If it isn't that we'll need the rest of the statement to sort you out...

 

[stevecal]

sorry, you're in US date format that should therefore be

SELECT to_date('02-17-2001','mm-dd-yyyy')