Skip to Content (Press Enter)
UserImage.jpg
Haruna Kibirige
2Views
2Comments
ORACLE EXTRACT 
Question
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.
0
0
30 Sep 2014
Copy Link
2012-10-08 11-59-27
Guilherme Pereira
Staff
Hi Haruna,

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



Cheers

0
0
01 Oct 2014
Copy Link
2012-03-16 12-21-09
João Rosado
Staff
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
1
0
01 Oct 2014
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.