That is not a command that would run on Oracle.
There is no DATETIME data type in Oracle, and trying to cast a date to a float would produce an error.
This is probably from SQL Server, and the goal of the command I suppose is to remove the time portion of the datetime column.
In Oracle, you could do it this way:
<pre>SELECT TRUNC(valueddate) value_date