0
votes
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

Statistics

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

Visits by Source

User Actions

Users who voted for this posting

Subscribe:
Contact us to advertise on DelphiFeeds.com

Community Links

Torry Firebird News

Sponsor

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