The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

    • RT @ProperlyZuri: One of my favorite things at Reason is our continued coverage of “Florida’s Worst Cop.” Sgt. German Bosque—arrested 3 tim… 2 hours ago
    • RT @mljmljmlj: 1/ One of the most important libraries in the world is being called a pirate site & being sued for bankruptcy. I'm shocked… 2 hours ago
    • RT @SwiftOnSecurity: I have a friend who works at an org with their own TLD. Except they can’t use it because some of their network tools d… 2 hours ago
    • RT @ziyatong: yup. https://t.co/lBraJvOIJr 2 hours ago
    • RT @WIRED: It's safe to assume that any digital evidence that you were at or near a protest could be used against you. Here is how you can… 2 hours ago
  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,929 other followers

Archive for February 17th, 2016

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

Posted by jpluimers on 2016/02/17

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 TTime values, the date parts would always be “1899-12-30” (yes, I like ANSI DATE and TIMESTAMP formats). Oracle doesn’t get that, so I wanted to get the time portion.

Solutions:

Read the rest of this entry »

Posted in Database Development, Delphi, Delphi 10 Seattle, Delphi 2005, Delphi 2006, Delphi 2007, Delphi 2009, Delphi 2010, Delphi 7, Delphi XE, Delphi XE2, Delphi XE3, Delphi XE4, Delphi XE5, Delphi XE6, Delphi XE7, Delphi XE8, Development, OracleDB, Software Development | Leave a Comment »

 
%d bloggers like this: