Vote UpVote

A script to check the frequency of Oracle log switches | Oracle DBA tips

The Wiert Corner – A wile ago, I had a this error when trying to get the TIME portion of a DATE column: ORA-00904: "TIME": invalid identifier This doesn’t work in Oracle, even though when you search for Oracle convert DATE to TIME you end up at this page listing TIME as a function: 12.7 Date and Time Functions. Alas, that page is for MySQL which is owned by Oracle for a while now. Back to the query which was like this where date_column was of type DATE. SELECT id, date_column, TIME (date_column) FROM some_table That DATE type actually stores date+time, and since it was filled with Delphi ...
Favorite? Off-Topic? jpluimers @ 2016-02-17 06:00


Visits: 1057
Votes: 0
Favorites: 0
Off-Topic: 1

Visits by Source

User Actions

Users who voted for this posting

Contact us to advertise on DelphiFeeds.com

Community Links

Torry Firebird News


Please login or register to use this functionality.
(click on this box to dismiss)