ORACLE EXTRACT 

ORACLE EXTRACT 

  
I am trying to use "EXTRACT(seconds from (dateX))" but the system is warning me. The query works but is their anyway of resolving this or extracting seconds from a datetime without using extract. The DB is ORACLE.
Hi Haruna,

To get the seconds you could alternatively use the TO_CHAR function to get them.



Cheers

Hi Haruna,

It's also safe for you to hide that warning, since you know that your databade is oracle. Just right click it in the TrueChange tab and choose Hide Warning.

Also, there are planned improvements in the following releases of Platform 9 regarding advanced query warnings. ;)

Regars,
João Rosado