I have the below queries, where am I am getting assertion error:
- SELECT TRUNC(ABC_DATE, ‘MI’) FROM TABLE_1;
- SELECT CAST(TRUNC(ABC_DATE, ‘MI’)AS TIMESTAMP) FROM TABLE_1;
And I am getting Failure finding function: trunc(timestamp) for the below query:
3. select TRUNC(ABC_DATE) FROM TABLE_1;
Can anyone help me around to see if this is a known issue or I am doing some mistake? As the same query is working fine on the oracle DB.